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

(1) Share

Report

Posted on by KT-10062044-0

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:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Michael E. Gernaey 53,493 Super User 2025 Season 2 on at

Like (0)

Report

hi @KT-10062044-0

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.

Was this reply helpful? Yes No
KT-10062044-0 4 on at

Like (0)

Report

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! : )

Was this reply helpful? Yes No
Michael E. Gernaey 53,493 Super User 2025 Season 2 on at

Like (0)

Report

Hi @KT-10062044-0

Looking at this give me a few

Was this reply helpful? Yes No