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 Power BI Community,
I have a dataset that has 1.4 million records; however, initially, I only want to grab records based a single criterion (campaign field is not null).
Below are my steps in the Query Editor:
I want to use the incremental refresh to only pick up updated data moving forward. Based on my steps above, I'm getting all 1.4 million records from the start (Apply query changes are taking quite a long time.).
Am I doing this right? How can I improve it?
Thank you for the support!
Hi @SoDoLabs,
What is your data source?
Normally, we could clear data in Query Editor as you did in Query Editor.
In addition, you could could use T-SQL Query to pull the data you want.
Based your description, it seems that you want to use incremental refresh , please note that the feature is for Power BI Premium.
Best Regards,
Cherry
Hi @v-piga-msft,
Thank for replying!
My data source is Dynamics 365 CRM.
Since the data is from Dynamics 365 CRM directly, T-SQL is not an option, unless I load the data into a on-prem database.
We do have Power BI Premium; however, the refresh time (w/ incremental refresh) was way to long. I found other posts on the Power BI Comunity that mentioned the same thing, the api connection is very slow.
Any sggestions?
Thanks,
Joe
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
102 | |
93 | |
73 | |
60 | |
59 |