Power BI scheduled refresh

[ankit_joshi11]

If I publish my dashboards on the server and insert all the credentials of the SQL server. Will the duplicate sheets refresh automatically. As I have not taken those sheets from the get data but duplicated the sheets from the power query. 

Thanks

[PC2790 · Accepted solution]

Hello @ankit_joshi11 ,

As part of the scheduled refresh,the main dataset will be refreshed and everywhere it is being referenced either in Power Query as duplicate table or duplicate sheets in desktop will be updated accordingly

[v-xulin-mstf · Accepted solution]

Hi @ankit_joshi11,

When connecting with Import mode, all the duplicate sheets will send queries to data source after triggerring schedule refresh.

When connecting with DQ mode, tile cache will be refresh after triggerring schedule refresh.

Please refer:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

Best Regards,

Link

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

[PC2790 · Accepted solution]

Hello @ankit_joshi11 ,

As part of the scheduled refresh,the main dataset will be refreshed and everywhere it is being referenced either in Power Query as duplicate table or duplicate sheets in desktop will be updated accordingly

[ankit_joshi11]

Thanks @PC2790