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.
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.
Maybe you could try to import the views without union and do the relationship between table on powerbi.
You will do the RLS after that and it will still workWe don't know what your data looks like so advising can be difficult