Forum Discussion

mas's avatar
mas
Helper I
8 years ago

data(list) in dynamics 365

hello,

i have a problem,

when i connect my power bi desktop to dynamics 365 , i  get numbers .

explication: in order to collect list(in dynamycs365) ,but i get numbers . exemple :  i want to get :

1-new

2-smart

3-best

 

but power bi collect this:

19920213

19920214

19920212

 

question: how power bi can collect the data(informations), not numbers.?

Need Help

5 Replies

  • mas's avatar
    mas
    Helper I
    8 years ago

    i used powerbi optionSet xrmtoolbox ..but how creating relation between table "gap_powerbioptionsetrefs" and my existing table 'opportun..' ?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi mas,

       

      You can choose one column as group/category, then write formula to calculate count of collection number based on group column.
      After above operation, add calculate column to mark tag based on collection count.

       

      Regards,

      Xiaoxin Sheng

      • mas's avatar
        mas
        Helper I
        8 years ago

        hello, i do not understood your solution.