cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.