Forum Discussion
unable to display visuals after publishing the report using Direct Query
Hi there,
I am conecting Oracle DB to get data in PBI using Direct Query.
in the Desktop I am able to see all the visuals proerly. but after publising the report, the visuals are like
and at top of page I could see the error message
Can someone help me understand what went wrong
Hi Anonymous ,
In fact, the gateway does not work when you direct use power bi service to get data from private cloud Datasource.
If it is a cloud data source exactly as you said, please check whether the credentials are set correctly.To verify Credentials, click on “Edit credentials” and fill in what they should be. With Oracle you have to use a Basic Authentication Method. Then after that just fill in the Database’s Username and Password and Sign in.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Private Cloud is the same as on premise as far as the gateway is concerned. Even AWS needs a gateway, for example.
5 Replies
- lbendlin
Super User
Assuming this is an on-premise Oracle db - have you added the Oracle connection to your gateway and have you pointed your dataset to the gateway connection?
V-lianl-msftCommunity Support
Have you configured the gateway correctly?
power-bi-on-premise-gateway-configuration-steps-to-an-oracle-database
- V-lianl-msft
Hi Anonymous ,
In fact, the gateway does not work when you direct use power bi service to get data from private cloud Datasource.
If it is a cloud data source exactly as you said, please check whether the credentials are set correctly.To verify Credentials, click on “Edit credentials” and fill in what they should be. With Oracle you have to use a Basic Authentication Method. Then after that just fill in the Database’s Username and Password and Sign in.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.