An error occurred while processing the data in the semantic model.

Rohit_terkar · ‎10-24-2024

Hello Everyone,

I am facing and shcedule refresh error.

I am getting an below message. Could you help me undertsand and resolve the issue.
Thanks.

An error occurred while processing the data in the semantic model.

Refresh failed:

Pricing Trend has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

{"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>The given credential contains a property with a null value. Data source kind: SQL. Property name: Username. </ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: Pricing Trend.

lbendlin · ‎10-25-2024

You have provided incorrect credentials, namely a blank username.

View solution in original post

v-yohua-msft · ‎10-28-2024

Hi, @Rohit_terkar

As lbendlin said, your issue is caused by a missing or empty username in your SQL data source credentials. You can modify the data source credentials for the semantic model in your workspace on the Power BI service

You can check the following posts:

Solved: DM_GWPipeline_Gateway_MashupDataAccessError - Microsoft Fabric Community

Solved: DM_GWPipeline_Gateway_MashupDataAccessError error ... - Microsoft Fabric Community

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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