cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Super User

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
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)