PQ Data model in Excel and in PBI does not give same info

[al1981]

I am pretty fresh, so please let me know what missed... Really sorry for this basic question, but...

I created model with unique event qurry with Column Event ID and another query of all speakers on all events - Speaker with name and one column with Event ID

When i create Pivot with Unique event in Rows and Speakers in Value, i get # off speakers, which is ok (number is correct), but there is not way i would be able to get names of speakers related to one particular event? I tried with slicer etc...

When i tested this same model with import to PBI, all works like a charm... What i missed? 

Thank you!

[al1981 · Accepted solution]

Dear all

thank you! I did a huge mistake which I discovered just while converting to dummy data 🙂 PBI is a step ahead compared to Pivot Data model... I should double check things next time (beginners mistake)

[al1981]

Hi @Anonymous 

I will try ASAP, have real production data in, have to chage it somehow. Hope to come back ASAP

[Anonymous]

Can you share the file