Getting data from Dynamics 365 - access is forbidden

[wilson_smyth]

Im trying to get data into PowerBI from Dynamics 365 Online.

I am following the steps listed in this article(detailed below) https://community.dynamics.com/nav/b/threadpunter/archive/2017/09/21/connect-power-bi-desktop-to-dyn...

1. Get the Web API URL from CRM

In get data, click on "Dynamics 365 (online) and click Connect

2. Enter the url and click ok

3. Click "Organizational Account" and then Sign in. I am signing in using an account that is admin in the CRM instance.

4. Click connect. 

5. it takes a few mins but comes back with a list of entities:

6. Select any entity. I get an "Access is forbidden" error, despite the fact that my account is an admin in CRM. I have tried with all authentication methods but none work.

Id appreciate any help or advise.

[v-yuezhe-msft]

@wilson_smyth,

I have no issues connecting to Dynamics 365 in Power BI Desktop. How about you connect to Dynamics content pack in Power BI Service? And what is the result when you connect to Dynamics 365 from other applications such as Excel?

Regards,
Lydia

[wilson_smyth]

Thanks for the reply.

I downloaded a content pack and edited the connection, clicked "apply and save". I get the exact same error: "access is forbidden".

with Excel, i get to the Navigator, exactly as with PowerBI, where it lists the tables/entities. When I select one of them it gives the same error "access is forbidden".

Account i am using is an admin in the CRM instance so i think it should be able to see everything.

[v-yuezhe-msft]

@wilson_smyth，

@KHorseman encounters similar issue in this thread, and the issue is related to licensing based on his description. I would recommend you verify if there are any issues with your license.

Regards,
Lydia

[wilson_smyth · Accepted solution]

I got onto MS Support and it was indeed a licensing issue.

Needed "Dynamics 365 Customer Engagement Plan" license (used to be called plan 1).

As i could administer CRM Online, and view the entites in PowerBI, just not thier data, i didnt think licensing was the issue but lesson learned.

thanks for the help all!