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

[trivita]

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.

[Greg_Deckler]

Connect to your SQL database?

[trivita · Accepted solution]

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

[walkingstar]

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 ?

[trivita]

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.

[walkingstar]

Thanks Trivita. Thanks for the code.

Could you provide details to configure Data Gateway?