Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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?
Solved! Go to Solution.
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
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Thank you. I do have a Power BI premium account and an Azure tenant. I'm currently working through the guide to set up the Embedded Analytics service. It's difficult to tell what the charges will be on my Azure tenant but I can try it for now.
I'm not sure Option 1 will work. It would require public visitors of my website to have an account for my organisation right? Maybe I could sign them up somehow.
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
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Thank you for your help
Welcome
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
82 | |
66 | |
61 | |
46 | |
45 |