Forum Discussion

aferrando's avatar
aferrando
Frequent Visitor
8 years ago

Exchange - Repeated IDs

Hi! I'm quite new on Power BI and I just found a weird problem that I'm not really sure what is causing it.   We are interested in monitoring data from an specific e-mail account in order to know (...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

aferrando,

What version of Power BI Desktop do you use? And do you import data from Mail table?

I make a test in Power BI Desktop June release(2.59.5135.781) and unable to reproduce this issue, I get unique IDs in my scenario. Could you please check if there are any settings in your Exchange?

Regards,
Lydia

aferrando's avatar
aferrando
Frequent Visitor
8 years ago

Hi Anonymous;

 

thank you for your answer. My Power BI Destop version is the same as yours (2.59.5135.781 64-bit (june 2018)).

 

We've continued investigating and we found that the problem is caused by Power BI. When we check the data in Power Query Editor, we don't find any duplicated value (in fact, there appears the correct e-mail URL). However, once we "Close & Apply" in editor, the data that is load in Power BI is different, and is here when appears duplicated data.

 

Top: Table data; Middle&Bottom: Power Query Editor
We have tested with others emails and has happened the same (even though was only one case).

 

Is there any chance to solve this issue?
If you need more information or examples, do not hesitate to ask for it.

 

Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    aferrando,

    I am still unable to reproduce this issue. Please create the following measures in your table and check if their values are same.



    Regards,
    Lydia

    • aferrando's avatar
      aferrando
      Frequent Visitor
      8 years ago

      These are our results:

      Thank you for all your assistance

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        aferrando,

        I would recommend you open a ticket in Power BI support.


        Regards,
        Lydia