Forum Discussion

dglsmason's avatar
dglsmason
Advocate I
11 years ago

CRM and missing fields

With Power BI Desktop, several fields are missing when I connect via Dynamics CRM Online. For example, OpportunitySet is missing Status and Status Reason. Why? Also, when I use the Power BI web (v 11...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
11 years ago

Did you use the Content Pack to connect to CRM Online? I used the content pack and I see both Status and Status Reason under OpportunitySet.

dglsmason's avatar
dglsmason
Advocate I
11 years ago

Thanks for your reply! The Content Pack is what I used from web, but from the Power BI Client, selecting "Dynamics CRM Online" for Get Data is the same as selecting oData. Without editing the query, Status and Status Reason are not included. It's like the Content Pack is really only available from Power BI on the web and not the client.

  • StNick's avatar
    StNick
    Regular Visitor
    11 years ago

    I'm still in the midist of initial tests and I had a similar issue with missing fields. In the past when I've selected multiple (2-3) entities to include in a dataset, it's taken 5+ hours of downloading before some issue or another comes up and I have to cancel or it's stopped. Today I selected 9 entities as a test and it finished within an hour. However those entities were missing fields.

     

    it seems to me that some issue occured while it was downloading data and it falsely reported completion. I ran another test, removing my multple entity selection and only chose one entity, and after an hour it finished and had all fields.