Forum Discussion

wilson_smyth's avatar
wilson_smyth
Post Patron
8 years ago
Solved

Getting data from Dynamics 365 - access is forbidden

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/conn...
Need Help
  • wilson_smyth's avatar
    wilson_smyth
    8 years ago

    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!

wilson_smyth's avatar
wilson_smyth
Post Patron
8 years ago

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.

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

wilson_smyth，

Anonymous 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's avatar
    wilson_smyth
    Post Patron
    8 years ago

    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!