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.

SQLArchitect's avatar
SQLArchitect
Frequent Visitor
7 years ago
Great idea. But many will overlook this possibility.