Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello community,
I have a data model where 3 tables are sourced from a direct query connection to the SQL server.
There are 3 pages and each page uses data from 3 different tables respectively. (It's a drill-down see details logic).
The report is meant to show live execution status, users have to manually refresh every 5-10 seconds to see status of latest jobs.
However, as they click refesh, all three tables start refreshing and it takes around 30 seconds to refresh all tables (the table on second page is large).
Is there any way to avoid refreshing all the tables in direct query when manually clicking refresh button?
For example, if i am on Page 1 and clicking refresh, it only refreshes first table, and then if i drill down to second page, it then sends query back to source and fetches real time data.
Do let me know, thanks 🙂
Solved! Go to Solution.
Hi @Jaykishan ,
The refresh button on the report cannot be set to refresh only one page. Maybe you can try to use automatic page refresh, and then set the refresh interval, it will automatically refresh each page separately.
Refer to:
Authoring reports with automatic page refresh in Power BI Desktop
Automatic page refresh in the Power BI service
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Jaykishan ,
The refresh button on the report cannot be set to refresh only one page. Maybe you can try to use automatic page refresh, and then set the refresh interval, it will automatically refresh each page separately.
Refer to:
Authoring reports with automatic page refresh in Power BI Desktop
Automatic page refresh in the Power BI service
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.