Forum Discussion
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...
PetrP not sure why are you using import method with Analysis Service, why not use the live connection. What is the point of having AS and using import? Seems to be a strange setup.
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.