cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
trivita Frequent Visitor
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

Accepted Solutions
trivita Frequent Visitor
Frequent Visitor

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

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

2 REPLIES 2
Super User IV
Super User IV

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

Connect to your SQL database?


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

trivita Frequent Visitor
Frequent Visitor

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

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

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!