Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

View solution in original post

5 REPLIES 5
Greg_Deckler
Super User
Super User

Connect to your SQL database?


Follow on LinkedIn
@ 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not 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...

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 ?

 

 

 

Anonymous
Not applicable

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.