The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello,
I am writing a new report in Power BI that requires me to merge two tables/queries together which I have done via the merge as new function.
When I do a refresh the data the standard tables load rapidly but when it comes to the merge query, it sits for a few minutes "waiting for dsn...". The image below shows what I am loading which isn't a large amount of data. The first four queries load in 8 seconds but the merge took 5 minutes before completing.
I have spent the weekend trying to figure this out and have deselected "Allow data preview to download in the background", this being a common thing to do to improve performance.
Does anyone know why the merge is reducing the refresh to a crawl?
I do facing same kind of scenarion. Merging 6 tables and each tables is having 4 coulms and date,text and number type colums exist. when i make small change then merge query is taking lot time for evalution and waiting for DSN.
How to improve the performace.
What is the dataformat on the columns that you are using for your merge?
Currently, the tables are still in their original formats within our ERP system so will be various formats.
Thats right.
In that case you are using 2 or more columns to perform that merge. What I'm interested in is which datatype these columns have prior to the merge, as that can greatly affect the performance. 🙂
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |