Cannot load model - Direct Query using Service Pri...

mmccarver · ‎09-01-2023

I can't tell if it is an authentication error or if it is an error in the report itself

TomMartens · ‎09-03-2023

what is the data source, and is the data source up and running?

Does the data source support Service Principal authentication.

Not sure what a "Service Principal connector is?"

Regards,

Tom

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

mmccarver · ‎09-05-2023

I was able to check the Azure SQL logs when creating the connection and verified that the service principal is connecting to the database server.

I have "data connectors" as shown in the image. These use Service Principal Authentication method. This is all working as expected.

Is there an API to make the report use this Service Principal data connector?

Cannot load model - Direct Query using Service Principal connector