Forum Discussion

diverdown1964's avatar
diverdown1964
Most Valuable Professional
10 years ago
Solved

How do I change a query from Import to Direct Query?

I have a SQL Azure database that I can use Direct Query with for a new PBIX file. selecting the tables to load allows me to check the edit button and convert to Direct Query. However, I have previous...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi BR,

 

Thanks, I was fast coming to the same conclusion, I had the idea to copy the Advanced Editor code from the old file to the new direct query file and obviously started getting errors due to the transformations - makes sense just to start again and deal with the 'limitations' of the different connection type.

 

Cheers

 

Mark

mike_honey's avatar
mike_honey
Memorable Member
10 years ago

The newish copy & paste functionality in the Query Editor doesnt work in this scenario.  Somehow it copies across the Import setting to a PIBX with existing Direct Query queries, even though the PQL code is identical (and doesnt break the Direct Query "rules").  There's no visible UI setting on the query to fix this.

 

I'm doing it by starting with a DQ query, then duplicating that and copying the name and PQL script from my Import model.  Finally I rebuild the Relationships.

 

It's frustrating - surely this was an obvious "use case" when DQ was introduced?