cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Microsoft
Microsoft

Re: Manage > Data Sources grayed out

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
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.