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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors