Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
When I go to set up a new Oracle data source the DirectQuery option is disabled. How can I set up an Oracle database for DirectQuery?
Solved! Go to Solution.
Hi @kodemonki,
How do you connect to Oracle database in Power BI Desktop? If any connections of other data sources exist in Power BI Desktop or you connect to Oracle database via import option in current connection, when you connect to Oracle database again, the DirectQuery option is disabled as shown in the following screenshot.
Please start Power BI Desktop without any other connections and connect to Oracle as follows, this way, you are able to use the DirectQuery option.
Thanks,
Lydia Zhang
To remove a connection, go to File > Options and Settings > Data source settings. Click Global Permissions to see all of your saved connections. Select the one to remove and click Edit Permissions..., then Delete under the Credentials section. Click OK and the connection should be removed from the list.
Hi @kodemonki,
How do you connect to Oracle database in Power BI Desktop? If any connections of other data sources exist in Power BI Desktop or you connect to Oracle database via import option in current connection, when you connect to Oracle database again, the DirectQuery option is disabled as shown in the following screenshot.
Please start Power BI Desktop without any other connections and connect to Oracle as follows, this way, you are able to use the DirectQuery option.
Thanks,
Lydia Zhang
How do I remove/delete a connection? Whenever I restart Power BI the old connection shows. Should I just uninstall/reinstall? That seems unnecessary.
To remove a connection, go to File > Options and Settings > Data source settings. Click Global Permissions to see all of your saved connections. Select the one to remove and click Edit Permissions..., then Delete under the Credentials section. Click OK and the connection should be removed from the list.
Oracle is supported. Have you checked the limitations section in this article to make sure you aren't running into any of those?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |