Power Bi Incremental Refresh ( SSAS MD Cube Import )

[atul9063]

Hi,

 Due to large data set in cube,I m only importing filtered data from cube using MDX query.Now i have to implement Incremental Refresh but Native query is disabled.    

a) How would I implement incremental refersh when Native query is diabled ?  

[v-yulgu-msft]

Hi @atul9063,

Please follow below blogs to check the reason for the disabled "Native Query".

Power BI Native Query and Query Folding

Power BI check query folding with view native query

Best regards,

Yuliana Gu

[Anonymous · Accepted solution]

Short answer, you can't.  Query folding must be available.  Incremental refresh works by sending a bunch of smaller queries to the database.

This recent video coincedently covers what you are talking about:

https://www.youtube.com/watch?v=RnrCKn5ykCc