Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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". ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago


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's avatar
v-easonf-msft
Community Support
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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