topic power bi report server + dynamics 365 on-premise + refresh data in Report Server

power bi report server + dynamics 365 on-premise + refresh data

Anonymous — Sat, 30 Nov 2019 04:03:11 GMT

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.

Re: power bi report server + dynamics 365 on-premise + refresh data

Greg_Deckler — Sun, 01 Dec 2019 17:14:30 GMT

Connect to your SQL database?

Re: power bi report server + dynamics 365 on-premise + refresh data

Anonymous — Thu, 05 Dec 2019 09:48:59 GMT

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...

Re: power bi report server + dynamics 365 on-premise + refresh data

walkingstar — Wed, 01 Apr 2020 16:19:46 GMT

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 ?

Re: power bi report server + dynamics 365 on-premise + refresh data

Anonymous — Wed, 01 Apr 2020 17:02:33 GMT

i hope you like python.

walkingstar

the key here, is to do a trace using chrome/firefox dev console.

get the idea of the whole authentication process.

then automate the process using whatever programming language you are familiar with.

Re: power bi report server + dynamics 365 on-premise + refresh data

walkingstar — Thu, 02 Apr 2020 17:11:30 GMT

Thanks Trivita. Thanks for the code.

Could you provide details to configure Data Gateway?