Refresh/Auto refresh the Excel file

[Anonymous]

Hi there,

I have downloaded some data sets (csv formats) from PowerBI Desktop/Services, is there a way we can refresh the csv file or do some setting where the csv file gets auto refreshed? rather than downloading it again by opening the PBIX file. 

Thanks in advance!

Suhas

[kevin_chicaeme]

hi, i am having trouble updating an excel dataset directly from ondrive with the following error:
Cluster URI: WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net
Activity identifier: e0c5f708-739b-49f0-a9c3-a120f273239a
Application Identifier: 80c54ebf-4922-848d-ab60-847f80d49c7a
Time: 2020-07-23 16: 23: 39Z

Hello, I'm having trouble updating an Excel dataset directly from ondrive with the following error:
Cluster URI: WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net
Activity ID: e0c5f708-739b-49f0-a9c3-a120f273239a
Application ID: 80c54ebf-4922-848d-ab60-847f80d49c7a
Time: 2020-07-23 16: 23:39Z

[amitchandak]

@Anonymous , see if you can power automate to that.

[Anonymous]

how do i do that can you please help me? or provide a link to follow the steps

[v-xuding-msft]

Hi @Anonymous ,

Does it make sense? If yes, please accept it as solution. Others will benefit from this thread.

[v-xuding-msft]

Hi @Anonymous ,

Do you mean export file from Power BI automatically to keep it up-to-date? 

You could reference the blog to have a try.

https://www.thebiccountant.com/2019/04/01/export-data-from-power-bi-using-microsoft-flow/

Note: Unfortunately this method will not work in the Power BI service.