Forum Discussion

icerdeira's avatar
icerdeira
Frequent Visitor
2 years ago

Option Set problem using Dynamics 365

Hello,   I have created a new option in a set of Dynamics 365 options. Until now it worked correctly and when I added a new option, it generated a column "name" that I used in my report. I have cre...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Could you be working from a cached optionset?  I.e. is the option set in another Query that holds the contents that you are left joining in?  If so, could you go to this other query and 'refresh preview' to see if the new option turns up?

 

Alternative, did you add this new option to the same Dynamics environment that is the source of your query?  I.e. did you add it to a DEV environment but you are connected to your TEST environment?

  • icerdeira's avatar
    icerdeira
    Frequent Visitor
    2 years ago

    The query is up to date and I am working on the production environment. I have tried to create a new BI report and it still does not work. Every option set I add returns the name as null. 

     

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      What connector are you using in your Source row?  Is it CommonDataService.Database(<YourURL>)?

       

      I'm wondering if you are using an older connector.

      • icerdeira's avatar
        icerdeira
        Frequent Visitor
        2 years ago

        I'm using the Dataverse conector.