Forum Discussion
Streaming Dataset - Page refresh Admin interval 30 minutes in Premium workspace
Hi Leroy. Thank you for the additional materials but I'm afraid the PPU settings are already 1 Second, but I still have the issue that if I build a report from a streaming dataset I cannot set the page refresh lower than 30 minutes. I guess the expected behaviour is to build a dashboard and not a report, but I find the visual options too restrictive.
We have circumvented the issues by building a CDC table in Azure with a direct query in Power BI, this can then have the 1 second page refresh enabled and gets the desired results without using a streaming dataset.
So although not resolved I am happy for this thread to be closed. Appreciate you taking the time to reply.
Shameless bump as still having this issue with the steaming dataset. Really want to avoid using a dashboard as want to build a composite model and have a report that refreshes regularly. Very much appreciate any help that can be offered. Thank you
Hi,AdmVarr
Has the problem been solved? If it does, share your solution and accept it as a solution that will help other community members who have the same problem as you.
If not, you can also check if the setting of the location here makes a difference:
Of course, the storage mode also affects it, here is a screenshot of the official document:
Links to the following official documents:
Automatic page refresh in Power BI Desktop - Power BI | Microsoft LearnBest Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Leroy. Thank you for the additional materials but I'm afraid the PPU settings are already 1 Second, but I still have the issue that if I build a report from a streaming dataset I cannot set the page refresh lower than 30 minutes. I guess the expected behaviour is to build a dashboard and not a report, but I find the visual options too restrictive.
We have circumvented the issues by building a CDC table in Azure with a direct query in Power BI, this can then have the 1 second page refresh enabled and gets the desired results without using a streaming dataset.
So although not resolved I am happy for this thread to be closed. Appreciate you taking the time to reply.Hi,AdmVarr
We're glad you found a solution for CDC tables in Azure and direct queries in Power BI to achieve the desired 1 second page refresh and would like to share it. This sounds like a smart solution.
It's even better if you're willing to accept your idea as a solution, it's very helpful for our community, community members have the same problem, they will find a solution faster.
Thank you for your contribution to the community and I wish you all the best in your endeavors.
If you need further assistance in the future or have more questions, please do not hesitate to contact us.
Have a nice day!
Best Regards,
Leroy Lu