Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Disabling "Include in report refresh" not working

Hi everyone,   I have about 10-12 reports that load the same Calendar, a SSRS report, in their PBI reports. These PBIX are published in the Cloud and are scheduled to refresh themselves overnight a...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    " These PBIX are published in the Cloud and are scheduled to refresh themselves overnight as well as during the day."

    "Include in report refresh" option only works for Power BI Desktop, it doesn't impact the refresh process in Power BI Service.

    In Power BI Desktop, when  you disable "Include in report refresh" option, data will not update in report view of Power BI Desktop after you click "Refresh" button in Desktop.

    Regards,
    Lydia

SimonAurizon's avatar
SimonAurizon
Advocate II
4 years ago

I'm late to the party, but my own experimenting 24/01/2022 indicates that unticking "Include in report refresh" does now stop that query being updated when the pbix is published to the service and its dataset is refeshed.

Laurenz's avatar
Laurenz
Frequent Visitor
4 years ago

Hi SimonAurizon,
Better late then never join 😉

Has your Power Bi Service access to the datasource, where you disabled "Include in report refresh"?

If yes, try the same again with a datasource that it has no access to. Then the refresh will fail. At least that was the bahavior, last time I cheked.

So you can't use the disabled "Include in report refresh" to prevent the refresh from failing, when there are datasources the power bi service has no access to. And that would be the only senario I would like to use it.