Forum Discussion
Power Bi Incremental Refresh ( SSAS MD Cube Import )
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 ?
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:
2 Replies
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:
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
