Forum Discussion
Power BI scheduled refresh
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
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
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.
3 Replies
PC2790Community Champion
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
Thanks PC2790
- v-xulin-mstf
Community Support
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.
