Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all.
I'm looking to do the "incremental refresh" thing, where I use the RangeStart and RangeEnd parameters. For that, following the steps in this video, I need the "View Native Query" option to be enabled, which is not the case.
I realized while looking for solutions that it was because my table was from a SQL query, so I used that query to create a view table in my database.
I select new source and choose my newly created table, selecting the option to get data from Snowflake. But the Native Query option is still disabled.
Using this that I found on the Internet, I get this:
Anyone knows how to solve this? Or some page that explains it? Because honestly I have no idea what to do. Thanks!
Solved! Go to Solution.
HI @CLQ,
I'd like to suggest you take a look at the official document supported data source part if your data source not support for this feature:
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn
In addition, you can also check the following blog about expand the incremental refresh feature usages:
How to use Incremental Refresh on ANY data source! – PBI Guy (pbi-guy.com)
Regards,
Xiaoxin Sheng
@CLQ were you able to get this to work? I am in the same boat, trying to enable Native Query not numerous existing Snowflake data sources so that I can set up Incremental Refresh. Having no luck.
HI @CLQ,
I'd like to suggest you take a look at the official document supported data source part if your data source not support for this feature:
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn
In addition, you can also check the following blog about expand the incremental refresh feature usages:
How to use Incremental Refresh on ANY data source! – PBI Guy (pbi-guy.com)
Regards,
Xiaoxin Sheng
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |