cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
diverdown1964 Regular Visitor
Regular Visitor

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 previously created PBIX files that import the data. I can find no mechanism that will allow me to convert these queries to Direct Query mode. Is this possible?

1 ACCEPTED SOLUTION

Accepted Solutions
Bjoern Established Member
Established Member

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

9 REPLIES 9
theBIbutler Member
Member

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

Hi,

 

Did you ever get anywhere with this, got the same issue myself.....?

 

Cheers

Bjoern Established Member
Established Member

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

theBIbutler Member
Member

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

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
Advisor

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

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?

jaykilleen Regular Visitor
Regular Visitor

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

Despite this being marked as 'solved' the real answer is "You can't".

Highlighted
odegarun Frequent Visitor
Frequent Visitor

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

sgellida78 Frequent Visitor
Frequent Visitor

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

we have created a very complex report, are we serious that to change from import to direct we need to start a new report from scratch?? there must be another way, please advise as we are desperate 

thank you in advance

sgellida78 Frequent Visitor
Frequent Visitor

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

we have created a very complex report, are we serious that to change from import to direct we need to start a new report from scratch?? there must be another way, please advise as we are desperate 

thank you in advance

odegarun Frequent Visitor
Frequent Visitor

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 434 members 4,635 guests
Please welcome our newest community members: