Forum Discussion

JohnnyDax's avatar
JohnnyDax
Icon for Helper I rankHelper I
2 years ago

Incremental and Max Memory usage for a P1

Hi, I am currently in the process of migrating our Analysis Services (AAS) cube to Power BI. I have successfully transferred the full model into a PBIX file and set up incremental refresh for it. Ou...
Need Help
Tips and Tricks
JohnnyDax's avatar
JohnnyDax
Icon for Helper I rankHelper I
2 years ago

Hi pallavi_r ,

 

Thank you for your answer, i configured into "large dataset" setting with no luck. It still say 7,2 GB from the admin center and 22 GB from the Fabric Metrics App. The one time full refresh work fine, it's the second one, in increment that fail (only for full dataset size, for half ot if no issue).

 

I have no calculated columns, the heaviest table is directly loaded from a azure synapse pool with no PowerQuery step except the filter on RangeStart/RangeEnd date. 

 

I guess my last option is through XMLA endpoint but i don't know how to automatize the refresh process through SMSS or Tabular Editor.

pallavi_r's avatar
pallavi_r
Icon for Super User rankSuper User
2 years ago

Hi JohnnyDax ,

I get it now. The exact same issue I was also facing for the first time. I went for xmla end point partitioned based refresh from SSMS. Its not difficult to automate. But answer me if you have CI/CD devops configured. It doesnt work that well with incremental setting. Let me share if there is any already available blog. If not there I will give you the full steps in next comment.

 

Thanks,

Pallavi

  • JohnnyDax's avatar
    JohnnyDax
    Icon for Helper I rankHelper I
    2 years ago

    We do have CI/CD Devops but only for the ADF/Synapse part.