Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
Good Morning,
I created a user in Oracle and gave right to select, but it does not update the data in the online version.
When I use another user, who has full permission, the update is done normally.
What permissions do I need to give the Oracle user to read through the gateway correctly?
Sorry, a used a online translator. ![]()
Hi @ThiagoLRamos,
In your scenario, Power BI service will use the credential you typed for the gateway to access the Oracle database. The permission of this credential will determine retrieved data. So please check how many tables data are included in this report, then grant the user sufficient permission to access those tables.
Best Regards,
Qiuyun Yu
Good Morning,
Yes, I do that. In Desktop version I used the same user account to access Oracle database and it works.
But when i put the same credentials in cloud version, it pass in the test connection, but don't retriev the data.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 6 | |
| 3 | |
| 3 | |
| 3 | |
| 2 |