Forum Discussion

hermanos's avatar
hermanos
Frequent Visitor
3 years ago

Refresh Without Importing

Hi folks!

We have a cube dataset that we use through Adobe Analytics into Power BI.
We have to manually refresh this dataset every month with latest month data. In order to make this refresh, we import millions of data on Desktop every month and then publish it. 

 

As far as I know Incremental Refresh is not working because the data is cube. Is there another way to refresh all the data every month without importing it on desktop and uploading it back to PBI Service?

 

Thx in advance!

 

 

Need Help

6 Replies

  • rajulshah's avatar
    rajulshah
    Resident Rockstar
    3 years ago

    hermanos , do you want your data to be just of the latest month OR do you want historical data + latest month data?

    • hermanos's avatar
      hermanos
      Frequent Visitor
      3 years ago

      Hi rajulshah , I would like to have historical data + latest month data. Thank you!

      • rajulshah's avatar
        rajulshah
        Resident Rockstar
        3 years ago

        Hello hermanos ,

         

        You can create parameters in the Power Query which can be changed from Power BI Service directly.

         

        Please let me know if this cannot work for you.

  • luisrh's avatar
    luisrh
    Responsive Resident
    3 years ago

    I am wondering why you have to do this manually.   Is the dataset not available outside the firewall?   Have you looked into using a PowerBI gateway to allow PBI.COM to have access to that data?    If you could do that then the right approach would be to use Dataflows and its incremental refresh capabilities.    Please review the below for details  -  Using incremental refresh with dataflows - Power Query | Microsoft Learn

    good luck.