Forum Discussion
Union and Merging Slowing Performance Terribly
Hello All, I have a report which is using 20 SQL views and I am doing few transformations on each, then disabling their load and then creating a UNION of all 20 (the business need is in such a wa...
On PowerBI, are you using Import mode or Direct Query ?
When I was using DirectQuery it was the problem, it was too slow. The solution was to import data
- Quentin
- I am using import mode for each of the 20
Views, no direct query for now.Did you try not doing UNION and creating relation between tables on PowerBI ?
Else, are you using every column on your 20 tables ? I had the same issue, and creating view of my table with only the needed columns and keeping data only after 2013 solved my problem
- While troubleshooting this issue I did delete the UNION and the load was really quick but the UNION is definitely the issue, and I do need the UNION more so for making life easier when I do the row level security. Also, after this UNION process I merge it’s data with the Power Apps data as well in this model. So having the UNION is needed regardless.
