Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I'm trying to create a Direct Query Data to be able to show a data that refreshes every 15 minutes on the screen.
but whenever I connect to SQL, I'm getting this message whenever I go to Edit Query and click source. Will this affect direct query mode? or theres work around these?
Thanks
Hi @Anonymous ,
Based on my test, I can reproduce your issue here. I think it is a warning message that remind your it is not import type. And you cannot expand the column either.
Does it mean that it will not properly work under direct query? or it will work fine and just ignore the message?
because whats inside the "table" is what i need.
Hi Sorry to bother
Did you manage to resolve your issue
I am experiencing the same issue
its just a warning, my query still a direct query.
Direct Queries doesn't support all Power Query transformations. If you try to use one that is not allowed you get this message. Please remove the query step causing issue or share the Advanced Editor Queries.
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.
@AnkitBI wrote:Direct Queries doesn't support all Power Query transformations. If you try to use one that is not allowed you get this message. Please remove the query step causing issue or share the Advanced Editor Queries.
Thanks
Ankit JainDo Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.
I havent dont any modifications on the Query.
Heres the Advance Editor Code
let Source = Sql.Database("10.79.7.12", "DO1_DATA"), dbo_PTICounts = Source{[Schema="dbo",Item="PTICounts"]}[Data] in dbo_PTICounts
Sorry but not sorry to bump this. Did you ever figure out the cause? Because 3 years later and I have the same issue on many queries I make. Even the Sql.Database statement alone gives me this error
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |