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...
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