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.
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. 🙂
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 |
---|---|
95 | |
94 | |
80 | |
71 | |
64 |
User | Count |
---|---|
115 | |
106 | |
96 | |
81 | |
72 |