08-16-2018 03:40 AM
Hi, When I create multiple queries and uncheck the enable load on each query and then append all the queries and carry out transformations on the appended query, when I click the apply and load I get an error " Query contains transformations that can't be used for DirectQuery". For all the queries I only use Import from the Connection Settings.
I don;t want all the queries to show up in the data model as I am importing from multiple databases but I do want the appended query to show in the data model.
Am I doing something wrong ? or how can I get the apply and load to work.
In PowerQuery in Excel I would do this using the Only Create Connection but this does not exist in Power BI and was hoping that by unchecking the enable load I could achieve the same result as Only Create Connection.
08-16-2018 05:20 AM
to my knowledge you cannot use Direct Query with multiple databases
in general the unchecked 'enable load' gives the same result as connection only in Excel, so the approach seems fine
08-16-2018 05:41 AM
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.
10-04-2018 07:43 PM
I was having this same error and I think I found a work around or maybe this is just the way it works. Try renabling the load on all your queries which you use to append, then append the queries and load. Once the appended query is loaded disable the load on all the single queries.