Unable to query custom views using PowerBI

Hello,
I’m Emanuele from Italy. first of all, congratulations for dremio, it’s really fantastic.
I am trying to query views created from different sources using power bi but I always get the following error:

Log searching failed with exception VALIDATION ERROR: Object ‘json’ not found.

The same data interrogated directly on the source does not give problems.
Do you have any advice?

Thanks.

@eperrella Thanks for the compliments, when you go to the Dremio UI jobs page, you should a job created for the failed PowerBI job, would you be able to download the profile and send it to us?

share query

Of course, this is the failed profile.
Thanks
5d52b328-0755-4b8e-a4ed-df2b01f015d1.zip (7.3 KB)

Any news about this problem?

@eperrella It looks like PowerBI is generating the query with a back tick and Dremio is unable to parse the query. We have this issue with MSTR and we are able to escape it using the ODBC advanced settings

https://docs.dremio.com/software/client-applications/microstrategy/

It seems like we were able to reproduce this behavior in PowerBI too see PowerBi error on load any VDS - #14 by balaji.ramaswamy

Let me check if this fix is coming out soon

1 Like

If it helps, version 21.2.0 works for me through powerbi, but the latest does not.