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

SQLArchitect's avatar
SQLArchitect
Frequent Visitor
8 years ago

Can you elaborate on your technique stop refreshing what is essentially a 'static' table in a Power BI dataset, since there is no way with the Power BI Service to stop the service from refreshing specific tables?

 

 

Sokon's avatar
Sokon
Icon for Advocate V rankAdvocate V
8 years ago

We didn't change the default behaviour. It's more of a workaround. We simply load data from static sources that never change.

 

However, because it took us so long to provide the needed additional data sources via the gateway, our user took another approach: He loaded his static data in multiple "Enter Data" tables. He reported that you can paste up to 600 rows of data into the "Enter Data" experience so he split his data and union'd the tables again in query editor. Ugly, but it works for him.

 

Please help to upvote the idea to be able to change the default behaviour here!