topic Refresh Error in Report Server

Refresh Error

Anonymous — Thu, 24 Oct 2024 08:13:56 GMT

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.

Re: Refresh Error

lbendlin — Fri, 25 Oct 2024 21:32:02 GMT

You have provided incorrect credentials, namely a blank username.

Re: Refresh Error

Anonymous — Tue, 29 Oct 2024 06:25:14 GMT

Hi, Anonymous

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.

Re: Refresh Error

mohdmohideen200 — Sat, 08 Mar 2025 10:46:18 GMT

"Data source kind:" is the label, and "SQL" is the value associated with that label.

In this structure, "SQL" functions as a noun, representing the type of data source.