Forum Discussion
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 に予定しています。 |
- Anonymous1 year ago
errorMessageの解析結果より、
NpgSQL インストール途中の選択肢を変更する必要があり、
defaultの Npgsql GAC Installation が unavailable になっていることが判明。メンバーの開発者はいずれも.Net経験者ではなく、
GAC Installation 要るでしょ!
という発想にはならずに
インストーラーは何も触らず
Next / Yes / OK / I Agree を押しておけば
defaultでよろしくやってくれると思っていました。
そしてハマった状況です。
こちらの問題は解決済みです。
8 Replies
- AnonymousNot applicable
Hi Anonymous
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 - Open Settings:
- rohit1991Super User
Hi Anonymous ,
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.
- Akash_VarunaSuper User
Hi Anonymous 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.
- AnonymousNot applicable
errorMessageの解析結果より、
NpgSQL インストール途中の選択肢を変更する必要があり、
defaultの Npgsql GAC Installation が unavailable になっていることが判明。メンバーの開発者はいずれも.Net経験者ではなく、
GAC Installation 要るでしょ!
という発想にはならずに
インストーラーは何も触らず
Next / Yes / OK / I Agree を押しておけば
defaultでよろしくやってくれると思っていました。
そしてハマった状況です。
こちらの問題は解決済みです。
- AnonymousNot applicable
Hi Anonymous
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. - AnonymousNot applicable
Hi Anonymous
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 - AnonymousNot applicable
Hi Anonymous
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.- AnonymousNot applicable
解決済みです