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…
Archive
Tag: Excel
A Power Query Custom Function to Rename all Columns at Once in a Table
I am involved with a Power BI development in the past few days. I got some data exported from various…
Quick Tips: OData Feed Analyser Custom Function in Power Query
It’s been a while that I am working with OData data source in Power BI. One challenge that I almost…
Finding Minimum Date and Maximum Date Across All Tables in Power Query in Power BI and Excel
When we talk about data analysis in Power BI, creating a Date table is inevitable. There are different methods to create a Date table…