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

ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
7 years ago

Actually, there is a better work-around now that DataFlows are up in GA:

Configure each Source in a DataFlow, and each DataFlow can have its own refresh schedule. So DataFlow1 can be static data. Refresh it once and never again. DataFlow can be the transactional data that gets refreshed regularly.

Then create a Power BI model that uses BOTH DataFlows.

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

ToddChitt: When the data really IS static, I don't care if the source moves, do I?

However, you are absolutely right with dataflows: I can put my data there once an load it in all my datasets without the need to setup and maintain an extra gateway data source for it. That makes things a lot easier!

I'd say it solves the problem, even when it hurts me to think about that data nevertheless being loaded into the datasets without need during every refresh...