How to schedule refresh only few queries in a report

[jatneerjat]

Hi,

I have a report in which I have different queries which fetches data from different sources and I am using Import mode,now I want to schedule a refresh for some particular queries,how can I do that?

So below I want to schedule a refresh for the first query only from top.

[v-yulgu-msft]

Hi @jatneerjat ,

Currently, disable data refresh for certain queries is only supported in Power BI Desktop. Here is an idea for you to upvote.

Best regards,

Yuliana Gu

[jatneerjat]

@v-yulgu-msft 

Could you let me know how can I disable refresh for certain queries in pbix and once I disabled the queries and then published the report so on refreshing all the queries will refreshed or only the enabled one?

[v-yulgu-msft]

Hi @jatneerjat ,

Under Query Editor mode, right click dataset, deselect "Include in report refresh". This dataset won't update when you refresh the report in desktop version. While once you publish report to Service, this setting will be ignored, all queries will be refreshed.

Best regards,

Yuliana Gu