Forum Discussion

nirvana_moksh's avatar
nirvana_moksh
Impactful Individual
8 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

nirvana_moksh's avatar
nirvana_moksh
Impactful Individual
8 years ago

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.