Forum Discussion

Strizzolo's avatar
Strizzolo
Icon for Advocate II rankAdvocate II
6 years ago
Solved

Incremental Refresh download .pbix

Hi,

I have a question regarding Incremental Refresh. I know that, once published on the service and refreshed, I cannot download the dataset.

Is there a workaround? Can I disable, someway, Incremental Refresh and then download the .pbix?

 

Thank you all.

  • Hi Strizzolo ,

     

    One workaround, you can turn off Incremental refresh on Power BI Desktop, and then republish it to Power BI Service and replace the earlier report. After this, you can download the PBIX file.

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

8 Replies

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support

    Hi Strizzolo ,

     

    One workaround, you can turn off Incremental refresh on Power BI Desktop, and then republish it to Power BI Service and replace the earlier report. After this, you can download the PBIX file.

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Strizzolo    what happens if something happens to your desktop version and you need the one that is in the cloud to make changes to it?  So once you upload is it locked and lost to you?  This seems like a major disadvantage to me.

      • zuheirashraf17's avatar
        zuheirashraf17
        Icon for Advocate II rankAdvocate II

        We just about to implement the incremental refresh option. But this issue has stop us from proceed to implement it. Being able to download it from the cloud bring a huge advantage to the team-based Power BI report development. When the report is published to the service and it is locked and lost forever in the cloud is not collaboration friendly I'd say.

         

        Hoping to find some alternative on this options.

  • karo's avatar
    karo
    Icon for Advocate V rankAdvocate V

    Hi,

     

    Any new ideas in this topic? I really would like to download the .pbix from cloud to change the parameter, however without a risk of historical data changes in the report.

     

    Regards,

    Karo

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User

      Icey's answer still stands as the fastest approach. You can play around with ALM Toolkit if you want, but that requires a lot more work.

  • JayUD's avatar
    JayUD
    Frequent Visitor

    Hi. Can incremental refresh be switched off / on using the Rest API?

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User

      Sort of. You can merge all partitions into one via XMLA commands and change the partition meta data. That will then be equivalent to not having set up incremental refresh.