Forum Discussion
Public report with directQuery does not shows the last information
Hi, perhaps this is a simple question. I have a report with the metereological data connected to my own local server in direct query mode (the aim is to see the current weather conditions). When published the report, it works fine and whenever i refresh the page in power bi service, the report is updated.
The issue is that this particular report is published as a public link and the link does not update the data as expected.
Any thoughts?
Hi , ajorquera
Based on your issue description, I've also made some research and query based on the feature you used for "power bi publish to web for direct query report", actually I found the direct query data connection mode is not very recommended and supported for the "publish to web" feature, This is because for the public published report, the data is cached for one hour from the time it is retrieved. If you update the report definition (for example, if you change its View mode) or refresh the report data, it can take some time before changes are reflected in the version of the report that your users view. When a data refresh occurs for an import data model, the service clears the cached data and retrieves new data. In most cases, the data is updated nearly simultaneous with the import of the data. However, for reports with many distinct queries, it may take some time to update. Since each element and data value is cached independently, when a data update occurs, a user may see a mix of current and previous values.
Since the direct query is the live data and will be refreshed very frequently, the live data is not that supported for this feature. And also as the reference of the official documentation, it's also mentioned as a limitation for this feature:
Publish to web from Power BI - Power BI | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , ajorquera
If you want to embed a report which its' dataset is using Direct Query mode , you can try to use the secure portal embed or embed analystics based on your actual need.
For these embed method , you can try to refer to and select the one you need:
Embed a report in a secure portal or website - Power BI | Microsoft LearnPower BI embedded analytics overview - Power BI | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
3 Replies
- v-yueyunzh-msft
Community Support
Hi , ajorquera
Based on your issue description, I've also made some research and query based on the feature you used for "power bi publish to web for direct query report", actually I found the direct query data connection mode is not very recommended and supported for the "publish to web" feature, This is because for the public published report, the data is cached for one hour from the time it is retrieved. If you update the report definition (for example, if you change its View mode) or refresh the report data, it can take some time before changes are reflected in the version of the report that your users view. When a data refresh occurs for an import data model, the service clears the cached data and retrieves new data. In most cases, the data is updated nearly simultaneous with the import of the data. However, for reports with many distinct queries, it may take some time to update. Since each element and data value is cached independently, when a data update occurs, a user may see a mix of current and previous values.
Since the direct query is the live data and will be refreshed very frequently, the live data is not that supported for this feature. And also as the reference of the official documentation, it's also mentioned as a limitation for this feature:
Publish to web from Power BI - Power BI | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thanks for the reply! Can you help me out indicating what is the best way to share public live data? Considera that i have to embed the information in a web page
- v-yueyunzh-msft
Hi , ajorquera
If you want to embed a report which its' dataset is using Direct Query mode , you can try to use the secure portal embed or embed analystics based on your actual need.
For these embed method , you can try to refer to and select the one you need:
Embed a report in a secure portal or website - Power BI | Microsoft LearnPower BI embedded analytics overview - Power BI | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
