Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
eddieuk1983
Regular Visitor

Data Source on uploaded report greyed out and not working - Oracle

Hi,

 

I am wondering if somebody can give me some advice....

 

I have created a simple test report on the desktop version of Power BI which hits my Oracle database fine.  Saving the same report on a Power BI Report Server and running it does not work even though the tnsnames information is correct.  

 

I have also noticed that the data source settings with in the report are greyed out:

 

greyed_out.png

 

However, I can create a data source on the Power BI Reporting server and test it fine:

 

success1.png

 

 success.png

 

I am fairly confident therefore the Oracle client info and tnsnames.ora server side are OK.  How do I go about playing with the data source on the uploaded report if it is greyed out?

 

Any help would be greatly appreciated.

 

Cheers

 

 

1 ACCEPTED SOLUTION

Hi,

 

THis was resolved by restarting the Power BI Reprt Server service.  The options are still greyed out but the data source actually now works.

 

Cheers

 

Ed

View solution in original post

2 REPLIES 2
eddieuk1983
Regular Visitor

Hi,

 

Any ideas on this one? 

 

Cheers

 

Ed

Hi,

 

THis was resolved by restarting the Power BI Reprt Server service.  The options are still greyed out but the data source actually now works.

 

Cheers

 

Ed

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors