connecting powerbi to dynamics crm

[mtaylor]

I am following the guide found here to try and connect powerBI to our on-premise Dynamics CRM https://technet.microsoft.com/en-us/library/dn708055.aspx  But the instructions are already written wrong when setting up the OAuth on the server, and so i dont have a whole lot of trust for the rest of the article. I was able to get OAuth enabled on the server, but the next part of the instructions say this: 

1. Register the Power BI Desktop OAuth 2.0 client with ADFS. To do this, open a Windows PowerShell window and run the following PowerShell command on the PC where you are running Power BI Desktop that will be used to publish your reports to the Power BI service.

   Add-AdfsClient -ClientId "a672d62c-fc7b-4e81-a576-e60dc46e951d" -Name "Microsoft Power BI" -RedirectUri @("https://de-users-preview.sqlazurelabs.com/account/reply/", "https://preview.powerbi.com/views/oauthredirect.html") -Description "ADFS OAuth 2.0 client for Microsoft Power BI"

This is confusing to me however, because it is saying you need to register it with ADFS on your desktop you are running reports from (my computer) but when I open up powershell to run the command i dont even have the ADFS Powershell module installed. Is this supposed to be run on a regular Windows 10 desktop? Is this the correct step but just written poorly? what is the next step to get powerBI configured to connect with an on-premise Dynamics CRM server once you have enabled OAuth on the CRM server?

Thanks so much for your help!

[v-yulgu-msft]

Hi @mtaylor,

You should meet below requirements to enable Power BI desktop to connect to On-premise Dynamics CRM:

• Windows Server 2012 R2 with AD FS 3.0 (required for Internet-facing deployment (IFD).
• For IFD, OAuth must be enabled on the Microsoft Dynamics 365 Server. This step is described in the following section.
• Microsoft Power BI account.

Best regards,

Yuliana Gu

[mtaylor · Accepted solution]

well thanks for nothing, but for anyone else that has this problem i found the answer. run this command on the ADFS server, completely disregard what microsoft says in their documentation and just run it on ADFS server

 Add-AdfsClient -ClientId "a672d62c-fc7b-4e81-a576-e60dc46e951d" -Name "Microsoft Power BI" -RedirectUri @("https://de-users-preview.sqlazurelabs.com/account/reply/";, "https://preview.powerbi.com/views/oauthredirect.html") -Description "ADFS OAuth 2.0 client for Microsoft Power BI"

[mtaylor]

The link that you just provided is the exact same link that i put in my question.... I have all of those requirements met. But the second half of the instructions on that page dont make sense. if you want to go ahead and read my question again that would be great.