How to enable functionalities in "data tab" if connecting to a data base (oracle) using direct query

[nalinda116]

can't use import option when connecting to Data Base (oracle) even with a single data table. Hence, had to use direct quarry option. But, "Data" tab is not available under direct quarry method. Hence, analytical capabilities are limited. Any solution if need to directly work with Data Base?

[v-yingjl]

Hi @nalinda116 ,

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!

Best Regards,

Yingjie Li

[v-yingjl]

Hi @nalinda116 ,

When we connect to datasource with Direct Querty mode, we could not use Data tab in power bi desktop unless we convert it into Import mode in the right corner of power bi desktop.

Here are the differences between selecting Import and DirectQuery:

• Import: The selected tables and columns are imported into Power BI Desktop. As you create or interact with a visualization, Power BI Desktop uses the imported data. To see underlying data changes since the initial import or the most recent refresh, you must refresh the data, which imports the full dataset again.

• DirectQuery: No data is imported or copied into Power BI Desktop. For relational sources, the selected tables and columns appear in the Fields list. For multi-dimensional sources like SAP Business Warehouse, the dimensions and measures of the selected cube appear in the Fields list. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you’re always viewing current data.

For more information about DirectQuery, you can refer the following Microsoft document hope to understand better:

1. Use DirectQuery in Power BI Desktop 
2. About using DirectQuery in Power BI 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[az38 · Accepted solution]

Hi @nalinda116 

it's the sense of DirectQuery - all request are sending to server from visuals

Create a table visual if you need to see a table