Forum Discussion
Append Queries returns an error
to my knowledge you cannot use Direct Query with multiple databases
https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery#limitations-of-directquery
in general the unchecked 'enable load' gives the same result as connection only in Excel, so the approach seems fine
Hi Stachu,
Thanks for the reply.
I have used Import not Direct Query (in the Connections Setting dialog box).
I have created queries (1 per database) and for each query I have unchecked "enable load", and then created a new append query to append the queries. I then carried out transformations on the appended query and its only when I try and load the ap[pended query that I get the Direct Query error message.
Regards
Peter
Peter2 im getting the same issue, any resolve on this?
