Combining X Number of Rows in Power Query for Power BI, Excel and Power Query Online
A while back, I was working on a project involving getting data from Excel files. The Excel files contain the…
Archive
Category: Excel
The Story of my Book, “Expert Data Modeling with Power BI”
In 2020, the world celebrated the new year with many uncertainties. Well, life is full of uncertainties, but, this one…
Quick Tips: Connecting to Excel Files Stored in SharePoint Online from Power BI Desktop
Microsoft Excel is one of the most common data sources for Power BI. We can store Excel files in various…
Quick Tips: Renaming All Tables’ Columns in One Go in Power Query
I previously wrote a blog post explaining how to rename all columns in a table in one go with Power…