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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Craig5
Regular Visitor

Manage > Data Sources grayed out

Hi, we've been trying to upload a PowerBI report to the report server using a DirectQuery connection however we've been getting an error when publishing it through the application:

 

powerbierror.PNG

 

On the report server, the report is there but it doesn't load any data on the screen. I viewed a previous thread and the solution says to click on Manage then Data Sources to store the credentials on the report server however when we try to access that it's grayed out:

 

https://community.powerbi.com/t5/Report-Server/PowerBI-Server-October-DirectQuery-to-SQL-Server-tabl...

 

grayedoutdatasources.PNG

 

Any assistance on this would be greatly appreciated thanks!

1 REPLY 1
v-yulgu-msft
Employee
Employee

Hi @Craig5,

 

  • What is your PBI Report Server and PBI desktop version? To enable DirectQuery connection, you should use the October release and use the matched desktop version. Besides, what is the data source type in .pbix file?
  • Do you get this error with all reports or just a particular one?
  • If you Save the report to disk using Save As and then try to upload it on the Web Portal does it work?
  • Also, please check the RSPortalXXX and RSPowerBIXXX logs in the installation LogFiles folder and let me know if you see any errors?
  • Do you install both SSRS and PBI report server on the same machine? If so, please check whether you configured the same server URL reservations for them. You need to make sure they both point to differant catalog databases and their URL reservations for both Web Service and Web Portal are differant.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors