Refresh failed

[chihiro_aoyama]

セマンティック モデルでデータを処理中にエラーが発生しました。

更新に失敗しました:

Refresh failedを更新できませんでした。
エラーの詳細: 内部サービス エラーのため、最後の更新試行が失敗しました。これは通常、一時的な問題です。後でもう一度やり直してもこのメッセージが表示される場合は、サポートにお問い合わせください。

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"<ccon>指定された資格情報に、NULL 値のプロパティが含まれています。データ ソースの種類: PostgreSQL。プロパティ名: Username。</ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: budget_tracking v_予算区分マスタ.

次回の更新はA005_収支管理表_試験実行中 - 予算比率 を 2025 年 6 月 11 日 8:30 UTC に予定しています。

[v-agajavelly]

Hi @chihiro_aoyama 

Just checking in one last time. Were you able to try out any of the suggestions shared earlier? If your issue is resolved, marking the accepted solution would be a big help to others who might be facing the same scenario.

If you went in a different direction or still need support, feel free to drop a quick update, we’re happy to keep helping.

Regards,
Akhil.

[chihiro_aoyama]

解決済みです

[v-agajavelly]

Hi @chihiro_aoyama 

Just following up to check if everything’s still working fine on your end. If you’ve run into any other issues with Microsoft Fabric or Power BI, feel free to reach out here or post in the Microsoft Community Forum — always happy to help!

If the previous reply helped, a Kudos or marking it as Accepted Solution would be appreciated.

Best regards,
Akhil

[v-agajavelly]

Hi @chihiro_aoyama 

Thanks for conforming the issue has been resolved by reaching out the fabric community. In future if you have new issues related to Microsoft Fabric and Power BI please do reach out Microsoft Community Forum.

If the above information helps you, please give us a Kudos and marked the Accept as a solution.

Best Regards,

 Akhil.

[chihiro_aoyama · Accepted solution]

errorMessageの解析結果より、

NpgSQL インストール途中の選択肢を変更する必要があり、
defaultの Npgsql GAC Installation が unavailable になっていることが判明。

メンバーの開発者はいずれも.Net経験者ではなく、

 GAC Installation 要るでしょ！

という発想にはならずに

インストーラーは何も触らず

Next / Yes / OK / I Agree を押しておけば

defaultでよろしくやってくれると思っていました。

そしてハマった状況です。

こちらの問題は解決済みです。

[Akash_Varuna]

Hi @chihiro_aoyama The credentials have a NULL value for the username. Verify and update the credentials in Data Source Settings or your Gateway configuration, ensuring a valid username and password are provided. Test the connection to confirm it works and retry the dataset refresh. If the issue persists, update the gateway or contact Power BI support with the error details.

[rohit1991]

Hi @chihiro_aoyama ,
During data processing with the semantic model, an error occurred resulting in a failed refresh. The detailed error message indicates an internal service error, which is usually temporary. However, if you continue to see this message after trying again later, you should contact support for assistance.

The underlying error appears to be related to the data source credentials for PostgreSQL, specifically a missing "Username" property (the property value is NULL). This caused the refresh operation for the table "budget_tracking v_予算区分マスタ" to fail. The next scheduled refresh attempt for "A005_収支管理表_試験実行中 - 予算比率" is set for June 11, 2025, at 8:30 UTC. If the problem persists, it's important to review your data source credentials, especially the username, to ensure they are set correctly.

[v-agajavelly]

Hi @chihiro_aoyama 

Thank you for using Microsoft Community Forum. 
Follow bellow steps to resolve your issue.

First go to Power BI Service (app.powerbi.com) then Log in to your Power BI workspace where the report/dataset is published then find Your Dataset Go to "Datasets + Dataflows" in the left-hand pane, or go to your workspace and locate the dataset (A005_Income and Expenditure Management Table_Exam Running - Budget Ratio).

• Open Settings:
  Click the ellipses (⋯) next to the dataset → Settings.
• Check the Data Source Credentials:
  Scroll to the section titled "Data source credentials".
• Re-enter the Credentials:

• If the status shows "Invalid" or "Not set", click Edit Credentials.
• Choose the appropriate authentication method (usually Basic for PostgreSQL).
• Enter a valid Username and Password for the PostgreSQL database.
• Click Sign In / Save.

• Test the Connection:
  After saving, try refreshing the dataset manually to check if it works.
• Confirm Scheduled Refresh:
  If the manual refresh succeeds, your next scheduled refresh should also work as expected.

If solution was helpful, please mark it as Accept Answer and click Yes to confirm. Feel free to let us know if you have any further questions—we’re here to help!

Best Regards,
Akhil.G