Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Column 'Id' in Table 'Calendar' contains a duplicate value

I've started to use the Power Query to report on my Office 365 Calendar items. Everything has been going great until I started receiving the following.   Calendar Column 'Id' in Table 'Calendar' c...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

First check the relationship in Manage Relationships to see if correct relationships are created. Then, go to Query Editor,  right click the [Id] Column select "Remove duplicate".

 

Regards,

Yuliana Gu

jcoffman's avatar
jcoffman
Frequent Visitor
8 years ago

This worked for me.

 

I'm not sure what happened as I hadn't touched my dataset queries in weeks...just having the 'daily refresh' go out there and do its API calls to grab new data. Failed starting yesterday and opened the pbix via desktop app and sure enough, there were a *ton* of random relationships built for whatever reason.

 

Removed all of them, refreshed the data, republished and everything is back to normal.