Forum Discussion
Appending Queries Issues
nirvana_moksh,
For all the tables except the append query, disable "Enable Load" option in query editor, this way, apply only the append query to report view of Power BI Desktop. When data changes in your source tables, click "Refresh" in Report View of Power BI Desktop to bring new data to append query.
If append query still takes long time, create the append table with DAX instead by using UNION() function. Or you can create the append table in SQL Server and then import it to Power BI Desktop.
Regards,
Lydia Zhang
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,
LydiaWhen 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