Limiting Data Refresh while manually refreshing in a Direct Query Model

[Jaykishan]

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 🙂

[v-kkf-msft · Accepted 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.