Forum Discussion
Automatically export refreshed data from power bi web to excel
Hi,
Not sure if this is the right part of the forum for this but any help would be appreciated
I have a requirement that for one of my dashboards that refreshes at 8am, that upon the refresh happening the data from one of the tables is automatically exported into excel. I'd like to use python for this if possible, is there a way does anyone know?
3 Replies
Hi brightonshock
What is the logic to understand which rows are refreshed, is there any date condition?Hi PijushRoy It is just one table that automatically refreshes at 8am each morning via sql view
Hi brightonshock ,
Have you considered trying Analyze in Excel which gives your users a live connection to the Power BI dataset?
Here is some additonal information:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-power-bi-datasets-excel
https://key2consulting.com/how-to-use-power-bi-analyze-in-excel/
