Forum Discussion
Helper IAbout Scheduler Refreshing
Hi Eeryone,
I have an Below error While I have Connected with an Refresh Scheduler and I cant Able to Rectify the Error where it is occured and the Data Source is Connected through SQL.
Data source error: Column '<pii>rowid</pii>' in Table '<pii>TABLEAU_REPORT TRD_CLI_PAYOUT_CURDATE_VS_LASTDAY</pii>' contains a duplicate value '<pii>15590304</pii>' 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 URI: WABI-INDIA-CENTRAL-A-PRIMARY-redirect.analysis.windows.net
Activity ID: f39df1cb-4ea8-4d1a-ab7b-15a7f6782e55
Request ID: 60eb7326-1a68-ded3-8099-13d0073ff8db
Time: 2022-04-18 04:48:01Z
Hello,
Sounds similar to Dataset not refreshing and cannot figure out - Microsoft Power BI Community
>> Remove the duplicate record >>Else You need to update your relationship between Tables based on the columns from one to many to many to many
Let us know if the suggestion works for you
Regards,
Ritesh
Mark my post as a solution if it helped you| Gentlemen & Ladies|Munde and Kudis| I like your Kudos!! !!
My You Tube Channel !! Connect on Linkedin || Power BI for Tableau Users
2 Replies
- ribisht17
Super User
Hello,
Sounds similar to Dataset not refreshing and cannot figure out - Microsoft Power BI Community
>> Remove the duplicate record >>Else You need to update your relationship between Tables based on the columns from one to many to many to many
Let us know if the suggestion works for you
Regards,
Ritesh
Mark my post as a solution if it helped you| Gentlemen & Ladies|Munde and Kudis| I like your Kudos!! !!
My You Tube Channel !! Connect on Linkedin || Power BI for Tableau Users 
PC2790Community Champion
Looks like the one of the columns in your table of SQL data contains a duplicate value which is not getting accepted by Power BI as it is connected to the other table by one to many relationship and has to be unique.
Try locating that culprit record by:
> Opening your report in Power BI desktop
> Open Power Query
> In the applied steps, try refreshing each step and locate the erroroneous step.
That way, you will be able to trace the table with duplicate values