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/
@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.
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
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
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.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Learn about the exciting things that happened in July.
All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.
Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.
We have great updates this month! Click the link for the video with more info.