Forum Discussion
power bi report server + dynamics 365 on-premise + refresh data
have anyone succesfully make these two work together.
what i have achieved now is:
i can successfully connect powerbi desktop to dynamics 365 on-premise, and develop reports. (oauth enabled)
but if i upload the pbi file to power bi report server. data cant be refreshed. this is frustrating.
i can see the reason why coz currently power bi report server only supports web data source with Windows NTLM authentication and basic authentication. OAuth+organization authentication isnt supported.
any thoughts on this?
thanks.
- Anonymous6 years ago
thanks Greg.
but I ended up with writing a data gateway myself to automate an ADFS authentication process (WS-Federation protocol), then act as a reverse proxy to the ODATA api.
Golang rocks btw...
5 Replies
- Greg_DecklerCommunity Champion
Connect to your SQL database?
- AnonymousNot applicable
thanks Greg.
but I ended up with writing a data gateway myself to automate an ADFS authentication process (WS-Federation protocol), then act as a reverse proxy to the ODATA api.
Golang rocks btw...
- walkingstarFrequent Visitor
Could you give any details on how you configured your Data gateway. I have sent a personal msg as well. Can you get back to me ?