Hello Gents, I have a Power BI report, and i managed to insert a power automate button, once clicked, it updates an excel sheet on the cloud with a new rows includes data already viewed in the report. for some reasons, i need to collect this data once daily, even no change in the values, so i have to click it manually once everyday.
my questions is, is there any way i can schedule this button click or to trigger this flow automatically without clicking everyday ? Thanks in advance..
Where is the data coming from behind the power bi report? If you can get access to the source object if it is in SQL you can extract the data directly from there.
If you have premium capacity, you could try creating a paginated report and using the export report option then parse the file contents into the excel document.
Lastly if you can setup the API to run a dax query against a power BI dataset, this is not the most DIY friendly approach since it potentially requires some IT assistance to setup and approve the azure application required to build out the API connection.
I'd love to be able to do this too!
I feel like I've seen an article saying it can be done with an http request setup for this but i can't find it!
User | Count |
---|---|
27 | |
16 | |
15 | |
12 | |
11 |
User | Count |
---|---|
43 | |
30 | |
28 | |
24 | |
23 |