Forum Discussion
Report using DirectQuery not refreshing on public embed report vs. website/portal
My use case is that I have a live data stream which I must make publicly visible on my company's website.
To do this I created a report which uses a DirectQuery SQL Server data source.
When I share the report there are two different options 1) portal/website 2) embed (public)
For option 1 (portal/website) when the live data stream is updated the report does show the new data (however only after refreshing the report with f5, is this possible without manually refreshing the browser?). However the problem here is that it requires authentication.
For option 2) (embed public) when the live data stream is updated, the report does not get the new data, even after a manual refresh.
Is this expected behaviour?
Is there some way to force the public report to get the new data?
Is there a better way to achieve my use case?
No, visitors won't need your organisation account
Please go through all the documentation here, you will find all your answers
https://learn.microsoft.com/en-us/power-bi/developer/embedded/embedded-analytics-power-bi
7 Replies
Hi AEdmonds1990
By default the refresh of a dataset in a Direct Query Mode is done every 15 mins. It is also refreshed on demand when a user play with slicers and filters in the report. Using the first option is a normal behavior.
For Option 2, I don't think you are using Power BI embedded analytics solutions
https://learn.microsoft.com/en-us/power-bi/developer/embedded/embedded-analytics-power-bi... If not then it is normal behavior.
Thank you for your response. You are correct I am not using the Power BI embedded analytics solutions.
Can you please expand more on what the expected behaviour is in this case.
"Can you please expand more on what the expected behaviour is in this case." did you mean your case?
Option 1 is your best option if you are not planning on going Premium or Embeded solutions.
