Forum Discussion
When publishing a dashboard with imported data, will that dashboard reflect ongoing changes in data?
Hi,
I am trying to build out a dashboard using dataverse, however I am trying to decide whether to use import or direct qurey. Some of the queries I am trying to build are not supported in directquery mode and the data suggests that i should switch to import mode.
However, if i switch to import mode and publish that data/dashboard, when that data changes over time will that be reflected in the dashboard? or will it only show the data that was taken when I initially imported it?
&
IF the imported data shows live data when published on refresh than why can is process some queries while directquery mode can't?
Thank you,
Henry
Hi DynamicsHS ,
If you publish it as imported it will reflect the data when you published it, however in the Power BI Service you can set up scheduled refreshes to regular update an import model dataset.
See here for details: https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
2 Replies
- johncolley
Solution Sage
Hi DynamicsHS ,
If you publish it as imported it will reflect the data when you published it, however in the Power BI Service you can set up scheduled refreshes to regular update an import model dataset.
See here for details: https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
- DynamicsHS
Helper II
Thanks John.