Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

How do you work with Dynamics 365

Hello,   I'm having trouble finding things in the database of Dynamics 365.   For exemple, I'm working with the table "OpportunitySet", someone add a combobox, I'm able to get the value "17600000...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi Anonymous,

 

Generally, to get data from Dynamics 365 to Power BI desktop, we can use Dynamics 365 Online or OData feed. See: Use Power BI with Microsoft Dynamics 365.

 

If you want to find where specific information is stored, you need to contact your Dynamics 365 administrator for help.

 

Best Regards,
Qiuyun Yu

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi, I'm already connected to Dynamics and the "dynamics 365 administrator" can't help, cause they don't know how everything is store in the Database.

     

    I think that an OpportunitySet is similar to every Dynamics, you can maybe add or remove stuff, but the base remains the same. It's easy to add a custom combobox with value link to an Opportunity. Its was also not that hard to find the value of that custom combobox for an Opportunity. The problem is where is the Label link to that.

     

    OpportunitySet.department = "1730001"

     

    But I need the texte value from it in Power BI, something like "Administration".

     

    I could create a table and copy the value/label in it, but I will have the problem somewhere else with some other properties.

     

    I'm sure there is a tool somewhere I could use the search the Database easily. The best way would have been able to connect to Dynamics database with Sql management, search plain text thrught the whole thing, and find the label.