Can't access the data source - DirectQuery & Oracle Database

[Anonymous]

Hi there, I have a user who was able to create a report in Power BI Desktop by connecting to an Oracle Database, and a Direct Query connection to two datasets.

• It worked on her machine but when published to Power BI service most of her visuals get the "Can't display the visual" error. 
• When I try to access it in Power BI Service I get the error ribbon "This report couldn't access the data source." 
• When I open the report on my machine, Power BI desktop completely crashes while asking me for credentials for the Oracle database: 
• 

• A gateway connection in the dataset for this report is up and running. 

I see now as I look into the gateway settings.... : 

That it's probably the DirectQuery that's failing rather than the Oracle Database? 

Any ideas or suggestions to fix this? 

[Anonymous]

Hi @Anonymous ,

One possible cause is that the DirectQuery connection to the Oracle database is not configured correctly in the gateway settings. You need to make sure that the data source name, server name, and database name match exactly with the ones in Power BI Desktop. You also need to check that the gateway has the latest version of the Oracle client installed.

Another possible cause is that the DirectQuery connection to the two datasets is not supported by Power BI service. Power BI service only supports DirectQuery connections to certain data sources. If your datasets are not in the supported list, you might need to switch to import mode or use a different data source.

Dealing with errors - Power Query | Microsoft Learn

Solved: DirectQuery error: DirectQuery may not be used wit... - Microsoft Fabric Community

Troubleshoot DirectQuery models in Power BI Desktop - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly 

If it does not help, please provide more details .

Best Regards
Community Support Team _ Rongtie

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