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...
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 work
We don't know what your data looks like so advising can be difficult