cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Duplicate column in rowset error when importing data

Hiya, I have received the below error when trying to refresh/import data into Power Bi. What does this mean and how can I fix it?  I have checked the tables it mentions and there is no duplicate columns titled "MONTH"

 

We couldn't import data from Sharepoint - Team Sites 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. Processing error: Duplicate column 'MONTH' in the rowset. An error occurred while processing table 'Tbl_WMdata'. The current operation was cancelled because another operation in the transaction failed. Duplicate column 'MONTH' in the rowset. An error occurred while processing table 'Tbl_Eastdata'. Activity ID: e837d486-777b-43b1-a56e-2e80b69f4e08 Correlation ID: 5eea0b6f-ad01-28a7-ee8e-b5dd4441a5e9 Request ID: 03dc277d-8235-c303-e853-4a91d076789b Status code: 500 Time: Thu Jul 02 2020 14:19:31 GMT+0100 (British Summer Time) Service version: 13.0.13736.165 Client version: 2006.4.01715-train Cluster URI: https://wabi-uk-south-redirect.analysis.windows.net/

6 REPLIES 6
Highlighted
Super User IV
Super User IV

Re: Duplicate column in rowset error when importing data

@Grizzlydad , Have you added any additional column at the source. Check that out.

Go to edit data sources in data transformation

clear permission and provide credentials and permission again.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Frequent Visitor

Re: Duplicate column in rowset error when importing data

Hi @amitchandak yes I have added columns in the original source, when I go to clear permissions it gives a warning saying there is now way of getting that back, so do I accept that?  If so how do I provide permissions and credntials again?

 

Thanks for your help

Highlighted
Frequent Visitor

Re: Duplicate column in rowset error when importing data

@amitchandak Hiya again, shall I delete the ermission and just refresh the data to import the new column?

Highlighted
Super User IV
Super User IV

Re: Duplicate column in rowset error when importing data

Highlighted
Frequent Visitor

Re: Duplicate column in rowset error when importing data

Hiya @amitchandak I am still recievin the same error message the new data will not load, this is a screenshot of the Power BI desktop when trying to refreesh the data

 

Grizzlydad_0-1594022200768.png

 

Highlighted
Community Support
Community Support

Re: Duplicate column in rowset error when importing data

Hi @Grizzlydad ,

 

According to the error, "Column 1" can't be found. What is it? If the column name in original source has been changed, it is suggested to change it in Advanced Editor manully.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors