Hi @Shahab Hogo, Thanks for the video very nice explanation Try to implement the same with Databricks as the source but i think query folding is not happening can you help me on these Thanks
Hi @abhilashpatel503 Thanks for your comment. First I created a newer version of this video around 2 months ago and I recommend to watch that one. Also I created another 2 videos on how to resolve query folding that may solve your issue
Hi, nice explanation. One question, does changes using tabular editor requires xmla endpoint read/ write option selected in power bi admin portal to apply in power bi service?
Good one! If I get it clearly, you have to make Parameters firstly to pursue Incr.refr at all? But is native query really needed or it can be done without it? Lets say my data if from "everywhere" and some of them from SQL...
Yes, for incremental refresh our query should support query folding. You can watch the another video on channel to learn completely how to enable query folding.
why did you created start_date and end_date paramters? you right clicked on a table, did incremental refresh, you gave past 2 yrs data to be archieved, refresh data was only for 2 months. Then at what stage start_date and end_date paramter helped you? why it was needed. Can you please explain briefly???? waiting for your reply............
Thanks for your comment. Parameters required for incremental refresh. However, the video has an editing issue. Please name the parameters as RangeStart and RangeEnd. They will work perfectly for you.
Really good explanation! I'm a visual learner so your walkthrough is helpful.
Thanks. Explained simply.
Very Good video. Thanks for the tips.
Thanks Martin. There is a newer version available on the channel released 2 weeks ago.
nicely explained, makes it clear to understand. thanks
Great explanation. Thank you
Hi @Shahab Hogo,
Thanks for the video very nice explanation
Try to implement the same with Databricks as the source but i think query folding is not happening can you help me on these
Thanks
Hi @abhilashpatel503
Thanks for your comment. First I created a newer version of this video around 2 months ago and I recommend to watch that one. Also I created another 2 videos on how to resolve query folding that may solve your issue
Hi, nice explanation. One question, does changes using tabular editor requires xmla endpoint read/ write option selected in power bi admin portal to apply in power bi service?
Good one! If I get it clearly, you have to make Parameters firstly to pursue Incr.refr at all? But is native query really needed or it can be done without it? Lets say my data if from "everywhere" and some of them from SQL...
Yes, for incremental refresh our query should support query folding. You can watch the another video on channel to learn completely how to enable query folding.
Can I use date instead of datetime ?
Good question. No you need to use date time
I thought the keywords RangeStart and RangeEnd were used for incremental refresh.
why did you created start_date and end_date paramters? you right clicked on a table, did incremental refresh, you gave past 2 yrs data to be archieved, refresh data was only for 2 months. Then at what stage start_date and end_date paramter helped you? why it was needed. Can you please explain briefly???? waiting for your reply............
Thanks for your comment. Parameters required for incremental refresh. However, the video has an editing issue. Please name the parameters as RangeStart and RangeEnd. They will work perfectly for you.
Sort out the display resolution in your videos. It's absolutely terrible. Almost unreadbale.
Will create a new one with better resolution