Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

direct query

WhatsApp Image 2019-02-09 at 12.38.08 AM.jpeg

 

The data is fetched from SQL server via direct query still the first line of "source" shows this message "This step results in a query that is not supported in DirectQuery mode(switch all tables into import mode)". The next "navigation" doesn't show any msg . So can you what exactly is the cause of this. Is there any proof or documention of this . Please help ASAP.

3 REPLIES 3
v-juanli-msft
Community Support
Community Support

Hi @Anonymous

Which version of Power BI Desktop do you use?

 

The next "navigation" doesn't show any msg.

Does this mean when you click on ""navigation", it shows data correctly without the warning: "This step results in a query that is not supportedin DirectQuery mode"?

 

Best Regards

Maggie

Greg_Deckler
Super User
Super User

Can you click on your query and then click Advanced Editor and copy and paste the text here? Is this the only Direct Query mode query in your file? Are you using composite models?


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Thanks, for your reply.We have taken the data only through direct query and its not a composite model.

 

here's the advanced editor code

let
Source = Sql.Database("machine-54", "AdventureWorksDW2014"),
dbo_DimCurrency = Source{[Schema="dbo",Item="DimCurrency"]}[Data]
in
dbo_DimCurrency

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.