Forum Discussion
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!
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.
2 Replies
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.
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.