Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi @roshanc10
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
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?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |