Import from Oracle database bring null values

[Anonymous]

Hi guys,

We have a stranger issue in the team.

We are pulling one view from Oracle database, and after import in Power query we can’t see data from two columns even though these columns have value in the Oracle view.

For one teammate everything is fine – he can see data correctly, but for two others - the issue appears.

We tried reinstalling Power BI Desktop, but it didn’t help.

 Has anyone had similar issue? Maybe you have some ideas where to look? 

Thanks in advanced

Have anyone dealed with similar issue? Maybe you have some ideas where to look? 

Thanks in advanced

[Greg_Deckler]

@Anonymous - Couple questions. Is what you are showing immediately after the Source and Navigation/Promoted Headers step or later in the transformation? If later in the transformation, can you post the Advanced Editor code? If you import the data (or is this Direct?) do you get anything? Could be a security issue on the database itself. 

[Anonymous]

Hi @Greg_Deckler 

Yes, it shows immediately, not just after the Source and Navigation steps, but even in data Load window.
We use import mode. With Direct connection we get the same result.

We had a guess that maybe there is something wrong with Power BI accounts and tried creating table in power BI Service dataflow, but in this case all three members see null in the table, even he, who can see values in PBI Desktop.

The only different that we found, is that the person, who see values, doesn’t have installed recommended provider (‚Oracle.DataAccess.Client‘). Maybe that caused the problem?

[Greg_Deckler]

@Anonymous Maybe but that's weird.

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[amitchandak]

@Anonymous , Open data in edit query/ Data Transformation, you should see some error there in yellow color or column with error and link. If so share the error.

[Anonymous]

@amitchandak  there is no error, just nulls, even though those columns have values in Oracle view.

Maybe it can be some security issue?

[amitchandak]

@Anonymous , Are you using the same user as your colleagues. If so create a new file and try. Make sure you are on the latest version of power bi. If required log an issue at https://community.powerbi.com/t5/Issues/idb-p/Issues