Forum Discussion
Powe BI Service Dataser
Hi, I ve made a report in Power BI Desktop using direct query. In desktop client works fine, but when I publish at Power BI service, data set donot show and I get a message "Cant load schema model". Im using direct query because I need to refesh every 30 minutes. I have a Premium account. Any help ? Thanks!
5 Replies
Did you setup a gateway? If not, I would start here - https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install
Hi Anonymous
If you have got premium did you know you can refresh the datset every 30minutes or even less if you want to?
Also as Shahfaisal either way you might need the gateway to refresh the dataset if not connected to cloud microsoft services (for example Azure SQL DB)
Hi, thanks for your responses.
I have a gateway, its works fine with my other reports using import query storage mode.
But this time I need a report that refresh every 30 minutes thats why I use direct query storage mode then
fails with "Cant load schema model".
This report uses Oracle DB connections, as Ive read every time the report refresh send the db credentials,
I believe that the problem its there. Do you know where can i check if the credentials are correct in PB Service ?Hi, Anonymous
In Power BI Service, go to refresh settings for the dataset. In Manage Data Sources, select Edit credentials to update the credentials for the data source.
Best Regards,
Community Support Team _ Eason
