refresh all reports on open

[Anonymous]

Looking for Mquery code to refresh all reports within Desktop version, preferably on open of workbook  Currently when I try to refresh all from menu, it is not refreshing all datasources.  The only way to refresh each report, is to select the report, then select the datasoucre and manually refresh each table/query.

There must be a quicker way to update/refresh the dataources/reports.

Please note that I currently do not have access to the report server, to schedule an update on a regular basis.

Any assistance is greatly appreciated.

Karen

[v-shex-msft]

Hi @Anonymous ,

AFAIK, power bi not support to refresh data from editing records, it can only get saved records which stored in excel file.

>> Currently when I try to refresh all from menu, it is not refreshing all datasources.

By default refresh button only 'refresh preview' query, you can click the drop down arrow and choose refresh all to 'refresh all' query tables list in query field.

Regards,

Xiaoxin Sheng