Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Solved! Go to 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:
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
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |