This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

Project Server Reporting with Power BI and Contact Pack

Question
0

Sign in to vote

Hi,

i am using On-Premises Project Server 2016, now i have to work on reporting. Can i use Power BI Desktop to build On-Premises Project Server 2016 reports. Can Project Online Content Pack for Power BI be used with On-Premises Project Server 2016.

pls guide what are other options to build custom reports. what OOTB reports are available for On-Premises Project.

Thanks

iffi

Wednesday, February 6, 2019 12:26 PM

Answers

0

Sign in to vote
Hello,

Yes you can use Power BI to connect to Project Server on-prermises either via the Odata API or directly to the Reporting schema in the SQL database. If you want to publish the reports to the Power BI service and get the report to refresh - you will need to look at the gateway such as this example here: https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial or look at using Power BI Report Server on-premises: https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/10/02/sql-server-2017-reporting-services-now-generally-available/

The Project Online Power BI content pack might need some tweaks but if you get the Power BI file these should be minor or it might just work. https://github.com/OfficeDev/Project-Power-BI-Content-Packs

As you are on-premises, you can use any reporting technology that can connect to a Microsoft SQL Server database - SSRS, Excel, QlikView etc. You should only query the reporting schema - pjrep schema.

Hope that helps

Paul
Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads
- Marked as answer by PWMatherMVP Friday, March 29, 2019 8:21 PM
Wednesday, February 6, 2019 1:18 PM