Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

direct query

  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 ta...
General Comment
Interesting Links
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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