Unable to Connect to CRM 2016 on premise

[jonathan_koh]

Hi,

Had been searching through and trying out the suggestion from this forum, still unable to connect to our on premise Dynamic CRM 2016 using OData Feed or Dynamic 365, 

Any ideas?

Thanks

[v-qiuyu-msft]

Hi @jonathan_koh,

Please follow this article to check if all settings meet requirements: Use Power BI with Microsoft Dynamics 365 (on-premises). Also can you show which error throws out when you get data in desktop?

Best Regards,
Qiuyun Yu

[jarrodm]

Hi I've followed the article mentioned, but i had several issues;

Firstly the PowerShell command 

Add-PSSnapin Microsoft.Crm.PowerShell
$fedurl = Get-CrmSetting -SettingType ClaimsSettings
$fedurl.FederationProviderType = 1
Set-CrmSetting $fedurl

failed with the following error from the trace "System.ArgumentException: ProviderType for Microsoft.Xrm.Sdk.Deployment.ClaimsSettings should be 0."

Then I noticed that the someone had commented that you needed to use the following instead;

$fedurl = Get-CrmSetting -SettingType OAuthClaimsSettings

Which appeared to work, but would be good to get some confirmation as the article was last updated in January 2017.

But after adding the client and following the remainder of the instructions, I am unable to logon through Power BI. We have other clients authenticating correctly using OAuth, but Power BI is just failing and I've not been able to ascertain why.

Any help would be greatly appreciated.

[Seth_C_Bauer]

@jonathan_koh If it's on premises, is there a reason you aren't just connecting to the SQL database?

[jonathan_koh]

Hi,

The system is customised and managed by our vendor. We are not allow to connect to the SQL server directly.