Forum Discussion

nirvana_moksh's avatar
nirvana_moksh
Icon for Impactful Individual rankImpactful Individual
8 years ago

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...
Need Help
nirvana_moksh's avatar
nirvana_moksh
Icon for Impactful Individual rankImpactful Individual
8 years ago
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.
quentin_vigne's avatar
quentin_vigne
Icon for Solution Sage rankSolution Sage
8 years ago

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