web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Building Flow to Expor...
Power Automate
Suggested Answer

Building Flow to Export multiple whole tables from Power BI to Sharepoint

(1) ShareShare
ReportReport
Posted on by 4
Can someone please help me figure out the right steps and query for this.  I am looking to create a flow that would allow me to export multiple tables from Power BI to a SharePoint Folder once a day.  
 
Here is the list of tables: 
[
  "Coordinates",
  "CSI 2-Project Length",
  "CSI Initiatives",
  "CSI Project List",
  "CSI Project List (2)",
  "CSI Project Request D...",
  "DateTable",
  "Issue Log",
  "Labels",
  "Locations",
  "SPMs"
]
 
And here is my flow: 
 
ChatGPT has me going in circles.  Basically, it always fails at the Create CSV table.  Can someone please help me create a new flow or solve this one? 
 
Thanks!
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,493 Super User 2025 Season 2 on at
     
    So I am guessing your variable has 11 table names and you are looping that variable, which is cool.
     
    However, what we need to do, is look at the Output from the Power Bi Query, to verify 2 things
     
    1. That the table you query has data, so you should look at the output first of within one of the Failed runs, we need the JSON specifically the RAW output of the Power BI Query
     
    We have to look at the JSON structure
    We then need to verify there is data
     
    Now for #2
     
    2. I don't know if your compose is just there to validate you have data, or if you are somehow just grabbing a specific set of JSON structure from the Query output, but what is the output of that statement?
     
    Is the compose the input to your Create Table? 
     
    Because whatever you are using for your INput is empty
     
    So either the table you queried first is empty, or you are pulling all empty data, OR you are grabbing the wrong Path in the JSON and its blank.
     
    So show me the money hehe or in this case the Outputs of the run actions etc.
  • KT-10062044-0 Profile Picture
    4 on at
    Haha, here's the money!! 
     
    But first, to answer your question about the Compose, Chat GPT suggested adding the step while I was troubleshooting.  Originally, it wasn't part of my flow.  I had the output of the RunQuery going straight into Create CSV table. 
     
    Output of the Run Query from the first table: Coordinates:
     
    [
      {
        "Coordinates[Location]""AMR Central",
        "Coordinates[Latitude]"37.68602,
        "Coordinates[Longitude]"-97.335571
      },
      {
        "Coordinates[Location]""AMR South",
        "Coordinates[Latitude]"33.748997,
        "Coordinates[Longitude]"-84.387985
      },
      {
        "Coordinates[Location]""AMR Pacific",
        "Coordinates[Latitude]"37.338207,
        "Coordinates[Longitude]"-121.88633
      },
      {
        "Coordinates[Location]""AMR Northeast",
        "Coordinates[Latitude]"40.712776,
        "Coordinates[Longitude]"-74.005974
      },
      {
        "Coordinates[Location]""Other",
        "Coordinates[Latitude]"1.202915,
        "Coordinates[Longitude]"-135.475818
      },
      {
        "Coordinates[Location]""LATAM",
        "Coordinates[Latitude]"-22.901449,
        "Coordinates[Longitude]"-43.178921
      },
      {
        "Coordinates[Location]""Canada",
        "Coordinates[Latitude]"49.895138,
        "Coordinates[Longitude]"-97.138374
      }
    ]
     
    Any suggestions on the next move? Thanks! : )
  • Michael E. Gernaey Profile Picture
    53,493 Super User 2025 Season 2 on at
     
    Looking at this give me a few

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 519 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 296 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard