Could not load the data for this visual - Unable to convert an M query in table [xxx] into a native

[rschaudhr]

I am trying to connect with Oracle using direct query. When I create the visuals on desktop everything works fine. When I publish the report to the service it gives me a blank visual like below:

The error associated with the visual is:

Now this error is only showing when I am using direct query and in the service. When I import the query and publish it to the service, then it is working fine. Did anybody run into this issue before?

Thank you,

Rehan

[Anonymous]

Hi @rschaudhr ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[Anonymous · Accepted solution]

Hi @rschaudhr ,

As the official document said, many data modeling and data transformations are available when using DirectQuery, though with some limitations.

If the Query Editor query is overly complex, an error occurs. To remedy the error, either delete the problematic step in Query Editor, or import the data instead of using DirectQuery. 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

show the M query.  Capture it in Power Query with the Advanced Editor.