Oracle obiee and power bi data not loaded

[mozakkir]

Hi,

I am new to power bi. I conncted power with oracle bi using bi connector 

https://support.biconnector.com/support/solutions/articles/8000048783-connect-power-bi-desktop-to-ob...

I am able to make connection to oracle BI and load subject areas and report in direct query mode. However data for these reports are not loaded and it loads below and says This table is empty

The appears when I click transform to "Use header as first row" I see the data appear.

as you can see in the warning it says that this step is not supported in direct query mode. Any suggestion on why data is not loaded from the first step it self.

Thanks.

[v-shex-msft]

Hi @mozakkir,

Based on test, current power bi not support custom operations in query editor, I think you need to switch to import mode to enable editor features.(sql statement also disable in direct query mode)

Regards,

Xiaoxin Sheng

[mozakkir]

Any help??