Couldn't load the model schema associated with this report.

[Anonymous]

Hi Community, I @need help in solving this error.

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.Hide details

• Activity ID57664868-867f-4802-bcb5-fb988a1a6d1e
• Request ID75b85aa3-aeb4-d570-a91c-a7cb5b70514c
• Correlation ID470944b6-d79e-c183-3528-c6d867e5acf6
• TimeFri Jan 29 2021 14:52:55 GMT+0530 (India Standard Time)
• Service version13.0.15255.54
• Client version2101.3.04559-train
• Cluster URI

  I have power bi PRO account, already using an On-premises data gateway (standard mode), using direct query mode and datasource to SQL server management studio.

[v-deddai1-msft]

Hi @Anonymous ,

 Any RLS settings apply on this dataset? Please aslo check if you maps to correct data source(New data source in your screenshot).  And if the account you used in credential have access to the database you used in dataset?

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

Best Regards,

Dedmon Dai

[v-deddai1-msft]

Hi @Anonymous ,

Have you configure the data source in the gateway? Would you please show us the screenshot of dataset settings? 

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

Best Regards,

Dedmon Dai

[Anonymous]

Hello dedmon

hello dedmon, yes I have configured it from the gateway. Please see above image. 

[lbendlin]

Does it work from Power BI Desktop?  What permissions do you have against the SQL Server?

[Anonymous]

Hello Ibendlin, Yes i published it from Power BI Desktop only. I have read only access on the server. It works perfectly fine on Desktop.