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 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
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |