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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

How to use Azure Devops data source in PowerBI Report Server

Hi Folks,
I have successfully saved the PowerBI Report to PowerBI Report Server.
In that PowerBI report, I can't able to get the Option Data Source (it was greyed/disabled) in Manage (it was greyed/disabled).

I am using Azure DevOps (Boards only) as a Data Source, but in Microsoft PowerBI documentation they said it was not a supported data source.
Reference:https://docs.microsoft.com/en-us/power-bi/report-server/data-sources

Here I want to get the report Data live in PowerBI Report Server.
Can anyone have any workaround for it?
Please Help!

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User

Your options are to either host your report on powerbi.com instead of Power BI Report Server, but the limitation there is that only other users with pro licenses will be able to view the report, unless you have licensed PBIRS through having a premium subscription in which case you could host this report on a premium capacity and share it from there.

 

Or you could use a script or SSIS package or something like that to pull the data from devops to one of the supported PBIRS data sources (like a SQL Server) and then you could link your report to that supported data source instead. 

View solution in original post

2 REPLIES 2
d_gosbell
Super User
Super User

Your options are to either host your report on powerbi.com instead of Power BI Report Server, but the limitation there is that only other users with pro licenses will be able to view the report, unless you have licensed PBIRS through having a premium subscription in which case you could host this report on a premium capacity and share it from there.

 

Or you could use a script or SSIS package or something like that to pull the data from devops to one of the supported PBIRS data sources (like a SQL Server) and then you could link your report to that supported data source instead. 

Anonymous
Not applicable

Hi @d_gosbell,
Thanks for the response, now I have connected DevOps with excel and using that excel in PowerBI Report.
Now it's working fine.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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

Top Solution Authors