Forum Discussion
How to use Azure Devops data source in PowerBI Report Server
- 5 years ago
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.
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.