Can't find Tab "Data" after import data from Oracle

[Kelly_Zhu]

Hi Everyone,

After connection to Oracle Database, I can't find tab "Data" on PBI as below image. Could you help me to find out? I need to use Dax formula to process the data. Thanks a lot!

[TomMartens · Accepted solution]

Hey,

the missing Data-Tab always indicates that you're accessing your source data in "Direct Query" mode, meaning that your Oracle Data is not imported, each action yields a SQL query against your Oracle data.

But it should be possible to add measures using DAX, for this either open the context menu of the table in the Fields pane and choose New Measure or go to the Modeling ribbon and choose New Meausre.

Hope this helps