Error : Step results in a query not supported in DirectQuery Mode

---

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 Jain

Do 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