Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Same dataset works refreshing from PBI desktop but gets error if refreshed from PBI onlone

 

The error I get when trying to refresh from PBI online is the following:

Something went wrong.
 
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source errorColumn 'XXXXXXX' in Table 'XXXXXXXX' contains a duplicate value 'XXXXXXXXXX' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
Cluster URIWABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID75f337d3-3711-4045-97c6-26089f7c32bb
Request ID2c68ddae-1ba7-9063-c380-a109770a121f
Time2017-03-02 07:04:48Z
 
 
The refresh does works from the desktop version. Also I have applied remove duplicates on the specific column and even applied remove the specific value on that column.
I did reuploaded the dataset in online after the applied removal.
 
 
Status: Needs Info
Comments
v-haibl-msft
Microsoft Employee

@Gabistoica

 

Please open the PBIX file and click refresh to get the latest data. Then check the relationship in Manage Relationships to see if correct relationships are created. Also go the errorColumn to check if there are duplicate values in it.

 

Best Regards,

Herbert

Vicky_Song
Impactful Individual
Status changed to: Needs Info