The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I created a report from PowerBI desktop using sql server ( on premise) and publised it to PowerBI service using Direct Query option . I have a managed gateway in server and this gateway is added to the published Dataset . It is Direct Query . If i try to run the report from PowerBI Service i am getting error Couldn't load the schema for the database model .
Any idea what could cause this problem ?
I created a report using Direct Query with sql server ( on premise) . Published it to powerBI service with gateway . Now i am trying to the report from PowerBI service but i am getting error Couldn't load the schema for the database model.
1. I have pro license
2. I have full access ( my uid) to database
If i do import with same gateway from same sql server all works ok .
Any idea ?
Hi @Anonymous,
This is one of common error messages, it is hard to troubleshooting from this message. Can you please share more details information about this?
Have you finished configure your datasource credentials on server side?
Regards,
Xiaoxin Sheng