Forum Discussion

atul9063's avatar
atul9063
Helper III
7 years ago
Solved

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 ...
Show and Tell
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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