Forum Discussion

tbyberg's avatar
tbyberg
Icon for Helper I rankHelper I
1 year ago
Solved

Migrating AAS models to Power BI Fabric / Capacity - setup incremental refresh post migration?

I am migrating just 4 AAS models to power bi fabric capacity. Post AAS migration, we end up with semantic models for each.  They seem to work fine and the data refreshes fine.  source is azure sql ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

You are mixing concepts liberally.  Incremental refresh only works with Import Mode data sources  (with the small footnote that the "hot" partition can be direct query).

 

You can use Tabular Editor to modify the partition rules if you like, and to retrieve the meta data without downloading the pbix. 

 

Maybe you can describe a bit more detailed what you are trying to accomplish?

  • tbyberg's avatar
    tbyberg
    Icon for Helper I rankHelper I
    1 year ago

    When the datasets were in AAS, we were updating only recent partitions of the tables into the AAS model.
    Reports were a live connection against AAS model.
    After migration to power bi, i am assuming the power bi semantic model needs refreshing somehow to get the new updated data. 

    After migration - if i just manually refresh the semantic model or put it on a refresh schedule -- i am not really sure what partitions are being updated, or if it is always a full refresh going that route?

     

    If i do not want a full refresh every time, what are my options?

    I am not too familiar with tabular editor -  i know we can manage partitions in there, but that doesn't drive what partitions get refreshed in the service does it?

     



      • tbyberg's avatar
        tbyberg
        Icon for Helper I rankHelper I
        1 year ago

        Thanks,

        Yes, it does look the same.

        We are utilizing a logic app to refresh specific partitions for the AAS models.

        Those processes could easily be converted to use the xmla endpoint. 

         

        I was looking to utilize the more automated partition management via the incremental refresh you can setup in desktop.

         

        However, I do see you can set something similar up using tabular editor.

        https://docs.tabulareditor.com/te3/tutorials/incremental-refresh/incremental-refresh-setup.html

         

        I'm new to tabular editor and look forward to utilizing that tool going forward.

         

        thanks again