I’m having an issue where Power BI isn’t recognizing the data in a new file when it is placed in a SharePoint. I can’t seem to find anyone having the same issue online, so hoping someone may have a solution here
I have set up 2 Power Automate flows:
- The first flow is designed to take the attachment received from an email and place it in a SharePoint folder.
- The second flow is designed to refresh my Power BI dataset once the file has been placed in the folder.
The flow seem to work fine, and PowerBI will recognize there is a new file in the folder, but it won’t show any of the data in the new file. When I go to Transform Data, I can see the new files, but when I go to the file, it shows no data. There seems to be an issue in the Expand Table Column1 step. I have tried setting this flow up a few different ways:
- First was replacing the file each time the flow ran, but this gave me errors, I thought it might be because the tab name in the excel file was named “Data”, but I’m not sure this is the reason it didn’t work
- Second, I tried adding a new file to the folder each time, this didn’t recognize the new files data.
- Third, I set up the report differently to not use the tab name “Data”, but I still get the errors where Power BI cant recognize there is data in the new files.
Advanced Editor:
Expand Table Column1 Step showing no data in the new file:
Flows:
Have you found a solution? I'm having the same problem.
You can replace the boilerplate code with your own file processing function. That way you have better control over the process and you avoid reading the first file twice.
If you provide a couple sample files I can take you through the steps.
