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

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

Not a very smart solution, I agree. But the most likely solution would be to provide a never changing datasource like an Excel and always load static data from there. You'd have to create an additional gateway data source though and might have a lot of unnessesary network traffic... 

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

SokonSorry, but that's known as 'defect support system'

What happens if the location of that static data moves? You don't NEED to refresh it, but Power BI Service FORCES you to, and then FAILS because it's not there. 

 

<rant>

This is a horrible design spec, where the desktop tool does something different than the service.

<\rant>

Sorry, but it's just my opinion.