topic Re: How to export a table with calculated measures to excel automatically each day in Developer

How to export a table with calculated measures to excel automatically each day

Anonymous — Fri, 18 Oct 2024 12:10:33 GMT

Hello,

I have a table created with calculated measures from different data sources into my report, and i want to exctract that table, preferably in a tabular form (for an LLM to read), in order to add that exported data into a daily flow. I dont want the underlying data, I want what the table shows as is.

Thank you all in advance!

Re: How to export a table with calculated measures to excel automatically each day

Greg_Deckler — Fri, 18 Oct 2024 12:51:04 GMT

@Anonymous Place your columns and data into a Table visual, hover over the visual, click the ellipses (...) and choose Export data.

Re: How to export a table with calculated measures to excel automatically each day

Anonymous — Fri, 18 Oct 2024 13:00:51 GMT

@Greg_Deckler Hi Greg, thanks for your reply. The thing is that i need for that table to get exported automatically, without touching a thing, in order for the flow to get the latest table data and get executed with the refreshed one.

Re: How to export a table with calculated measures to excel automatically each day

Anonymous — Mon, 21 Oct 2024 06:50:31 GMT

Hi @Anonymous ,

I think you can try to export data from power bi visual by power automate.

You can refer to this solved post with similar issue like yours, I hope it could help you solve your issue.

For reference:
Solved: export data from power bi visuals to excel automat... - Microsoft Fabric Community

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.