CODEWITHSUNDEEP
powerbim
asmgx
asmgx

Reputation: 7994

Change from "Import" to "Direct Query" in Power BI

I have 2 Queries in Power BI

one is Import and the other is Direct Query

I was looking at the Advance Editor for both queries.

they both look exactly the same, no difference what do ever

How can I change Import query to become Direct Query from the Advanced editor?

Import query script

let
    Source = Sql.Database("DSServer", "DSDB", [Query="EXEC stat_DailyNumbers"])
in
    Source

Direct Query script

let
    Source = Sql.Database("DSServer", "DSDB", [Query="EXEC stat_DailyNumbers"])
in
    Source

Upvotes: 3

Views: 11552

Answers (2)

Peter_Elfen22
Peter_Elfen22

Reputation: 57

no posible. Recread query in ReportServer PowerBi not possible.

Upvotes: 2

Pratik Bhavsar
Pratik Bhavsar

Reputation: 848

You cannot switch between query methods.

Workaround:

 1. copy the code from your advanced editor to notepad.
    
 2. Create a new query, where you will be able to choose direct query / import. 
    
 3. Open advanced editor for the new query and paste the code you copied earlier.

Upvotes: 3

Related Questions