Data load error

[Venu_Sunkara]

Hi Team,

 i created my report/chart in desktop and i succesfully published this report to my workspace, but in my workspace if i open my report file im getting this below error.

Cannot load model

Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.

Please try again later or contact support. If you contact support, please provide these details.Show technical details

Get helpCopy

Data Source is Azure SQL DB and i used directquery instead of import.

Thanks,

Venu Sunkara

[ibarrau]

Hi. You have to set the credentials for the datasource. Go to the dataset "Schedule Refresh". Then edit credentials like this picture:

edit cred

After adding this you shouldn't see that cross next to the database instance and you will be able to use the report from Power Bi Service.

Regards,

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

[Venu_Sunkara]

Hi ibarrau ,

i have done that part already with the authuntication method as Basic, eventhough im getting the same result if im using the import database option the report is generating well but not able to publish the report to public(publish to web).

Thanks,

Venu

[ibarrau]

Is everything ok in Power Bi Service? is the problem just publish to web?
Check the limitations on that skill to check if have all everything in order.

https://docs.microsoft.com/en-us/power-bi/service-publish-to-web

Regards,