Forum Discussion
Connect Power BI Server to Project Online API Data
In our version of PBIRS (May 2019) connecting to POL didn't work regardless of the auth method used; we came to the conclusion (internally and on the forums here) that it's a feature not currently available within PBIRS - PBI yes, Cloud Workspace yes, but Report Server, nope. I believe this was due to how it applies the authentication however as it works elsewhere it seems like it was mostly a shoulder shrug response.
To get around this limitation I automated a pulled the data from POL into a SQL DB and then made a connection to that SQL DB. It's a clunky workaround and I'm hoping that a more up-to-date version allows it but if not, this may be an option?
I've read on another topic that data gateway could be used...but I've not done this so I wouldn't know.