Reply
jrich_1995
Frequent Visitor
Partially syndicated - Outbound

Power BI Not Recognizing New Files Placed in a SharePoint Folder using Power Automate

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:

  1. The first flow  is designed to take the attachment received from an email and place it in a SharePoint folder.
  2. 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:

    1. 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
    2. Second, I tried adding a new file to the folder each time, this didn’t recognize the new files data.
    3. 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:

      jrich_1995_0-1689525971808.png

       

       

      Expand Table Column1 Step showing no data in the new file:

      jrich_1995_1-1689525971808.png

       

       

      Flows:

      jrich_1995_0-1689526051946.png

       

      jrich_1995_1-1689526058963.png

       


        

       

2 REPLIES 2
cseqtex
New Member

Syndicated - Outbound

Have you found a solution? I'm having the same problem.

Syndicated - Outbound

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.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)