Direct Query Power Bi online service

[WimBi]

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

[v-xiaoyan-msft · Accepted solution]

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.