Forum Discussion
Appending Queries Issues
I did already disable the load feature for the base tables and I do not want create this global view in my PROD SQL environment only to keep that cleaner and I wanted to do this at the report level, but regardless should this not be an easy and fast load for like a mere 1000 rows? That is what surprises me, I know if I create this appended UNION in SQL it will be quicker but why does it take so much longer in Power BI?
nirvana_moksh,
Do you Refresh data in Report view or Query Editor?
In addition, even if you have different layout columns in these tables, you can use UNION() function in DAX, there is a similar thread for your reference.
Regards,
Lydia
When I refresh data in the query editor using Refresh All it takes maybe 8-12 minutes, but when I hit Close and Apply, the refresh in the report view takes 29 minutes.
When I tried using the UNION DAX function with the 19 views it gave me the error of columns number mismatch.
nirvana_moksh,
Have you used SELECTCOLUMNS() function to choose same number of columns in each table? There is a similar thread for your reference.
https://community.powerbi.com/t5/Desktop/Union-thinks-column-numbers-are-different/td-p/174218
Regards,
Lydia