Cannot load model

[jwillis07]

Good morning all,

Hoping you can help... For the past week or so I keep getting this error message when trying to access reports from the Power BI service...

Republishing the dataset temporarily fixes the issue, but then it just happens again, about 2-3 times a day.

• I have a MariaDB SQL database, connected to Power BI through direct query.

• This file is then published (with 0 visuals) to a non-premium workspace

• Subsequent dashboards then use the published Power BI dataset which are then published to the same workspace.

• I have three reports/dashboards that use this dataset and all get affected by this error

I don't think there's anything wrong with my model as it works fine... until it doesn't... I know you can't see much here, but this is what my model looks like:

I've googled around and seen some suggested fixes that I've tried, none of which solved the issue:

1. Uninstalled and re-installed Power BI Desktop, then republish.

2. Download the PBIX file from the Service and republish from Desktop

3. Verified that all who access my workspace have Pro licenses and is not being accessed from anyone outside my organisation

Not sure if it's a coincidence, but I think this only started happening when I started editing reports in the Service.

Any tips on how to stop this happening would be massively appreciated.

Thanks in advance!

[MalcolmPorter]

I am also having same issue 

All Direct queries and seems to only do this between hours of 17:00 and 06:00 UTC  +2
Regards

[nssj1983]

I have the same case mentioned by @jwillis07. I haven't been able to add any new visuals to the app since last week. Displays exactly the same message.
(PT-BR)

[jwillis07]

Hi @nssj1983 Are you also using the MariaDB connector?

[Anonymous · Accepted solution]

Hi @jwillis07 ,

An internal ICM has been created.

ICM ID: 329977022.

If there's any progress, I will update it here.

Best Regards,

Jay

[jwillis07]

Hi jayw, has there been any progress on this?

I stopped getting this error for about a week but now it's back, and the fix of just re-publishing the dataset no longer works so essentially all my Power BI reports using this are just dead and I have no idea why it's happening or how to fix it. Incredibly frustrating!

Thank you.

[MalcolmPorter]

Hi @jwillis07  mine issue is the same, except mine seems to only effect after hours. During hours works fine. Is yours the same ?

[jwillis07]

Hi @malcolms

No, I'm experiencing the issue 24/7. I've had some video calls with Microsoft support over the weekend and potentially identified the source of the issue to be the MariaDB connector.

Switching to use ODBC works fine (however that obviously has limitations in that it only supports Import Mode)