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,
So I have to add two columns to my existing sql query in Power BI. I thought it would be fairly non time consuming. But the table the query referes to has 3.5 million rows and it takes hours to update. Is there an easy way, where I can add those columns without it querying the whole database?
Thanks,
Ritesh
I missed the part about you using your own SQL query. Query folding would not apply. Good luck.
Regards
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@Ritesh_Air , is it a direct query or import mode
@Ritesh_Air , see if you can schedule incremental refresh for this
https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
Thanks. I have seen incremental refresh before. It's for different purpose. What I want is to add few columns without refreshing the whole table. So I don't have to wait until it runs the query. Looks like there is no way to force it when I use 'sql query' as my data source.
Incremental refresh is for new set of data after certain date.
thanks
ritesh
Hi @Ritesh_Air ,
You can add some SQL statements to filter the data in advance when getting data from the data source then add new queries to add columns.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-yingjl
Actually, my whole query is SQL only. I was thinking of filtering it with one record to add the columns and then remove that filter but wouldn't it run again when I remove the filter?
All I want is to apply changes without refreshing the entire table, and let a person just use the service to do that...
@mahoneypat I am not sure how the query folding will help?
thanks,
Ritesh
Make sure you are maintaining query folding, if it is available for your source. Please see this link for more details.
https://docs.microsoft.com/en-us/power-query/power-query-folding
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |