cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
trivita
Frequent Visitor

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.

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

View solution in original post

5 REPLIES 5
Greg_Deckler
Super User
Super User

Connect to your SQL database?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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

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 ?

 

 

 

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.

 

未命名图片.png

Thanks Trivita. Thanks for the code.

Could you provide details to configure Data Gateway?

 

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.