Forum Discussion

PetrP's avatar
PetrP
Frequent Visitor
6 years ago

Incremental Refresh with Analysis Services source

Hi Everyone,   just I am trying to set-up Power BI incremental feature on report where the source is Azure Analysis Services.   But I have problem that I need to filter Cube Dimension (f.e. YearM...
Need Help
ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
6 years ago

I agree. I have a very similar setup: Analysis Services Tabular models running on premise and connected via the Gateway. 

 

In this setup, no data goes 'across the wire' until someone tries to render a page. Then Power BI will issue the query to the source SSAS Tabular model, and only the needed result rows, properly aggregated, get returned.

 

If you have Azure Analysis Services, you are already paying Microsoft for the memory allocation there. Why also bog down Power BI with extra data? 

 

Hopefully your data model is robust in its relationships, etc.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

PetrP I think you are missing the fundamentals here If you want, we can connect and discuss it over the team meetings/goto meeting, whatever works for you.