Connect to Dynamics 365 - DataSource.Error

[Talvien]

Hi all,

I try to connect to Dynamics 365. I get until the screen where I can select the entities.

Even when selecting only one entity it seems there is too much data for PBI too load.

I do always get an error like this:

DataSource.Error:=Data: Could not resolve remote name: xxx.xxx.dynamics.com

I saw an article where Excel was used as a layer between Dynamics and PBI to load via PowerQuery into the Excel, but it is from 2015.

Is there a build in solution for the problem meanwhile?

Thanks in advance!

[v-caliao-msft]

@Talvien,

In which step did you get this error? 

PowerBI is a great tool for reporting on and analyzing data, from a wide range of sources, including Dynamics 365. To set this up, you must connect to Dynamics 365 as a PowerBI data source, so PowerBI can load your CRM data. Here is a blog which provide step-by-step instructions for setting this up in PowerBI Desktop. Please refer to the link below.
http://www.powerobjects.com/2016/11/18/connect-to-dynamics-365-data-from-powerbi-desktop/

Regards,

Charlie Liao