Powe BI Service Dataser

[Anonymous]

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!

[Anonymous]

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 ?

[v-easonf-msft]

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

[Anonymous]

Hi ,

In the dataset I do not have that option, "administrator has granted access, credentials are not required". I imagine that it inherits them from the gateway.

Please note that our Oracle DB its not validated against AD.

Thanks

[GilbertQ]

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)

[Shahfaisal]

Did you setup a gateway? If not, I would start here - https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install