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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Anonymous 

I'm very confused with this.

So it means "Include in report refresh" option only affect PBI desktop, but when you refresh dataset in PBI service, the table still be refreshed, right?

Is that still correct now?

Laurenz's avatar
Laurenz
Frequent Visitor
4 years ago

When I last tired it (see Post) it prevented the refesh also in the service. But it would still need access to the datasource.

So if you have a datasouce that's just accessbile for your PBI Desktop, the refresh would still fail. Since the check which tables to refesh was done only after the check if there is access to the source.

But I have not tried since then.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Ya, but my purpose is to refresh table which is NOT Include in report refresh. Ofcourse, normally I don't want it to refresh (both clicking refresh dataset manually and schedule refresh), but sometimes there is an update, that I want to refresh that table in PBI service, so how to do that?

    • ToddChitt's avatar
      ToddChitt
      Super User
      4 years ago

      Anonymous If you have a dataset that is flagged as DO NOT INCLUDE IN REPORT REFRESH, I think the only way to refresh it is manually in Power BI Desktop. You must right-click on the table (in the Fields pane on the right) and select Refresh Data. Then you must re-deploy that refreshed model to the service. I don't think there is a way to manually refresh it from within Power BI Service.

      Hint: This is a great way to refresh only ONE table at a time during development or testing, when you don't want to wait to refresh ALL of your datasets.

      One other option is to take that dataset that you don't want to refresh and persist it as a DATAFLOW in the workspace. Dataflows can have their own Refresh schedule apart from other dataflows and models. In fact, the Dataflow need not have a Refresh schedule at all. This is a great work-around for data queries that don't change that often, like Zip Code lists, Employee lists, or Product lists. 

      Hope that helps

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thank you ToddChitt 

        I consider this is a shortage of Power BI service. We obviously have demands to do so but PBI service just cannot serve that. The way I am doing now is refresh it manually in desktop version and re-deploy it as you said and it's not convenient. That's why I'm here to ask for another way.

        For DATAFLOW way, I have try creating but it is apparently not an easy way.

        So seemingly I have no choice sticking with re-deploy way and wait for next update of PBI service.