cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dancarr22
Resolver I
Resolver I

How to replace an existing import query with a Dataflow direct query?

Hello,

 

I have a question in 2 parts:

(1) How do you get Direct Query to work with a dataflow?  I have followed the instructions here

mainly enabling enhaced computer engine for the dataflow - but direct query is not displaying as an option.  It just automatically imports and never asks to set to direct query.

(2) Once (1) works - need to change an existing import query (going against a SQL Server db) with the Direct Query Dataflow connection.  Normally I'd just go into Advanced settings of the data connection and update the connection info.  But, not sure if doing so will use Import by default.

 

Appreciate any assistance which can be offered.

 

Thanks,

Dan

 

3 REPLIES 3
dancarr22
Resolver I
Resolver I

Thanks @aj1973  - we do not use calculated columns.

Absolutely no way to do this?  Our data model has nearly 30 tables and various measure.  Would be very time-consuming if we had to rebuild the entire thing just because we can't toggle between Import and Direct Query.

Any way to go into the XML of the data model behind the scenes or something like that?

 

Thanks,

Dan

aj1973
Community Champion
Community Champion

@dancarr22 

To answer your first Question, yes the way you are thinking of is time consuming although you wouldn't need to change the connection mode of 30 Tables...only work on the fact table and leave the dim tables on import mode.

Can't answer your second question about XML... Could be interesting to me as well to know.

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

aj1973
Community Champion
Community Champion

Hi @dancarr22 

Replacing an Import connection mode by DQ mode is not possible. A simple example why this is not possible is that you can add a calculated column into an imported Table therefore the added column is not allowed to be added directly to the source.

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors