Direct Query Power Bi online service

WimBi — Wed, 10 Aug 2022 08:03:58 GMT

Hey all!

I have a problem what is somewhat still unclear for me; i am using MariaDb with a direct query connection on Power Bi Desktop and everything is working fine. when i want to Publish the file to the Power Bi online service, all the visuals online are just white and i get the following error message:

____

Cannot load the model

Cannot load the model schema associated with this report. Check that the server connection is active and try again.
Check the technical details for more information. When contacting support, provide these details.

Onderliggende fout: PowerBI service client received error HTTP response. HttpStatus: 400. PowerBIErrorCode: DatasourceAnalysisFailedWithUnknownFunctions
Activiteits-id: 5d9cae4d-6646-4f80-95e9-1743b834869d
Correlatie-id: 7d57e84e-f3d7-7030-4fc6-e2bc6db8494c
Aanvraag-id: 11dcd3a4-9bed-6ffb-bae6-1ba3894a5cab
Tijd: Wed Aug 10 2022 10:01:00 GMT+0200 (Midden-Europese zomertijd)
Serviceversie: 13.0.18800.35
Versie van client: 2208.1.12628-train
URI cluster: https://wabi-west-europe-e-primary-redirect.analysis.windows.net/

Has anyone have a solution to have a Direct Query connection with MariaDb??

Thank in advance - Willem

Re: Direct Query Power Bi online service

Anonymous — Tue, 16 Aug 2022 05:30:28 GMT

Hi WimBi ,

When you select the database , if the database has more then one cube, you will get the scema error.

You must specify a specific cube or perspective name.

Also you may try File -> Options and Settings -> Data Source Settings -> Tick "Global" -> select the data source -> Clear Permissions -> delete. and reconnect it..

Best Regards,
Community Support Team _ Caitlyn

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

topic Direct Query Power Bi online service in Report Server

Direct Query Power Bi online service

Re: Direct Query Power Bi online service