Data update error

[Hayashi]

重複する値が見つからない。

5 月 17 日以降、データの更新は失敗しています。

私はこれを解決するための手がかりが欲しい。

直前の更新が失敗しました: Thu May 19 2022 15:43:38 GMT+0900 (日本標準時)
データセット内のデータの処理中にエラーが発生しました。

データ ソース エラー:	表 '<pii>製番</pii>' の列 '<pii>SEIBAN_ALL</pii>' に重複する値 '<pii>\par }{\rtlch\fcs1 \af423\afs18 \ltrch\fcs0 \f423\fs18\kerning0\insrsid15411263\charrsid1 5411263 \~}{\rtlch\fcs1 \af41\afs18 \ltrch\fcs0 \fs18\cf17\kerning0\loch\af38\hich\af38\dbch\af38\insrsid15411263\charrsid15411263</pii>' これは多対 1 リレーションシップの片側のカラムやテーブルのプライマリ・キーとして使用されるカラム。
クラスター URI:	WABI-JAPAN-EAST-redirect.analysis.windows.net
アクティビティ ID:	38d7b55c-40f3-46fd-bf09-09040bf73a52
要求 ID:	0adedfc8-a8d9-422a-8ea6-f8822298186c
時刻:	2022-05-19 06:43:38Z

[Anonymous · Accepted solution]

Hi  @Hayashi ,

According to the error message, you can try the following:

1. You can turn off the "Auto-detect relationship" function in Power BI Desktop - File - Current file - Data load.

The " Auto-detect relationship " feature that is turned on by default has some tables joined without our knowledge, we can delete all these unnecessary created relationships and turn off the " Auto-detect relationship " feature.

2. You could remove the duplicate rows in query editor and try again.

3. Go to Model on the left bar and then click 'Manage relationships' under the 'Home' menu.

1.  Select which relationship is causing the issue and then deleted it.
2.  Open Power Query and then go to the 'Add Column' menu and click 'Index Column From 1'
3.  Refresh all queries and then click 'Load & Apply'.

This is the related document, you can view this content:

 https://community.powerbi.com/t5/Desktop/Get-quot-not-allowed-for-columns-on-the-one-side-of-a-many-...

Best Regards,

Liu Yang

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

[Anonymous · Accepted solution]

Hi  @Hayashi ,

Has your problem been solved, if it is solved, you can mark the correct answer, if not, you can provide more detailed content and questions, we can help you better.

Best Regards,

Liu Yang

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

[Anonymous · Accepted solution]

Hi  @Hayashi ,

According to the error message, you can try the following:

1. You can turn off the "Auto-detect relationship" function in Power BI Desktop - File - Current file - Data load.

The " Auto-detect relationship " feature that is turned on by default has some tables joined without our knowledge, we can delete all these unnecessary created relationships and turn off the " Auto-detect relationship " feature.

2. You could remove the duplicate rows in query editor and try again.

3. Go to Model on the left bar and then click 'Manage relationships' under the 'Home' menu.

1.  Select which relationship is causing the issue and then deleted it.
2.  Open Power Query and then go to the 'Add Column' menu and click 'Index Column From 1'
3.  Refresh all queries and then click 'Load & Apply'.

This is the related document, you can view this content:

 https://community.powerbi.com/t5/Desktop/Get-quot-not-allowed-for-columns-on-the-one-side-of-a-many-...

Best Regards,

Liu Yang

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

[Hayashi]

Hi@Anonymous 

Thank you for your reply.
Unfortunately, even after trying these, the data update failed.
However, when I changed the Excel file in question from a csv file to an xlsx file and recreated it, the data update was successful.
In addition, we have turned off the Auto-Detect Relationships feature of PowerBI Desktop.
I confirm that the data update will be successful after tomorrow.
Thank you very much.

Best Regards,

@Hayashi