Forum Discussion
Appending Queries Issues
Hello All This has been an ongoing issue and I have tried everything but now I almost feel as this is an issue with PBI. So I am connecting to a total of 20 SQL Views which on SSMS side run in to...
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
Also, the UNION in DAX wont work as the UNION in M would work because each view has a different layout of columns.