Tag: Power Query

  • Power BI – Combine all files from folder

    Power BI – Combine all files from folder

    In my last blog post, I wrote about the easiest ways to import data from Excel files hosted on SharePoint into Power BI. Another scenario that I encounter frequently is the use of recurring flat file exports from source systems like ERPs, CRMs, or databases, typically as daily or weekly exports. This approach is often…

  • Incorrect Power BI Report Data After Refresh

    Incorrect Power BI Report Data After Refresh

    You just spent a lot of time designing your report and now it’s time to upload it to the Power BI Service. After setting up the credentials for the data source, you hit refresh to make sure the data can be pulled from the source. The refresh completes without error and you switch over to…