Extract Power BI data & measures with Power Automate

[@stephencoates544]

this is brilliant for me, thanks

[@AccessAnalytic]

Great to hear!

[@chrism9037]

Very cool, thanks Wyn

[@AccessAnalytic]

You’re welcome

[@pthapa55]

Amazing, thanks.

[@AccessAnalytic]

You’re welcome.

[@willkhan6679]

Thanks for sharing. I've briefly explored the running query against a power bi dataset step, but I can only see my dashboard under the dataset selection. How do I set this up so that I have access to the dataset(s)? Currently, my report is built off dataflows that sit under my fabric workspace and my report is ingesting these as inputs. Have I gone wrong somewhere in this initial infrastructure setup?

[@AccessAnalytic]

So who built the model that your report is based on? Are you saying you don’t see the Semantic model icon when you go into your workspace?

[@willkhan6679]

Hello mate, I figured out the issue. As it is with these things the solution is often simpler than the problem. I forgot to publish the latest version of my model, so the dax query which was providing the expected output in the desktop version now works when I schedule the flow. All I had to do was publish the model to reflect the latest change I'd implemented in my desktop version of the pbix file. Duh. Thanks for your help 👍🏻

[@AccessAnalytic]

@willkhan6679 glad you got it working

[@saakshimankar6215]

Can we apply dynamic filter on our datset using this flow ?

[@AccessAnalytic]

I believe you could edit the query text to pass a dynamic parameter in. I’ve never tried though.

[@mienzillaz]

Worth mentioning how to loop through data model as there's a limit how much stuff you can call on one go.

[@AccessAnalytic]

Any tips?

[@mienzillaz]

@@AccessAnalytic usual you want to index your data in the model, set bunch of variables, one of which will be batch size, then initial value and optionally count for loops, as then at the end you want to append everything, and each CSV will have own headers, and you don't want them. Loop number will help you with that as then you can skip first row in CSV for loops beyond first one.

[@AccessAnalytic]

Cheers, so this as a workaround to a paginated report when you want large data exports and don’t have premium capacity ?

[@mienzillaz]

@@AccessAnalytic no, there's a limit when you query dataset in power automate regardless if the premium. In your case you called single value, so no risk there.. but if you want to catch a snapshot this is the only way..

[@AccessAnalytic]

Sorry, what I’m saying is a paginated report would be a simpler solution but that requires premium capacity. Any idea on what the data limit is?

[@davidanalytics1359]

Consider this scenario, I have a PBI report that refreshes everday and i want to extract that data and append it. I dont want it to overwrite the table but always append so that I have historical record. How can i do this? Please

[@AccessAnalytic]

The csv files could become your data source and then use “from SharePoint folder” connector to consolidate them? kzbin.info/www/bejne/Y4moaHt7j8eEn7ssi=YUWL7sGbRfEclx0H

[@stephencoates544]

i found a bug (perhaps), does anyone know a solution. Issue: although the query defines the COLUMN ORDER. I have found that if the FIRST ROW (record) has NULL CELLS (items) the column is MOVED to the END of the COLUMNS in the OUTPUT to .CSV.

[@AccessAnalytic]

Not a scenario I’ve come across yet