Power BI Semantic Model refresh issues

[blestone111]

Hi Experts

I out of nowwhere am now getting the following erro rmessage when i try to refresh the semantic model in Power BI Service and cannot work out what the root cause is..

The model has been refreshing fine on a schedule refresh for over 1 yr, and now the below....

error message

Data source error{"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":"The underlying connection was closed: An unexpected error occurred on a send."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"https://api.powerbi.com/powerbi/globalservice/v201606/clusterdetails"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}}

[Anonymous]

Hi @blestone111 

Is your gateway updated to the latest version? If not, try updating the gateway.

Best Regards,

Jayleny

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

[pbiuseruk]

Could you try restarting the gateway and then trying the refresh again.

[pbiuseruk]

Hi,

Looks like you may have a gateway and that gateway may be offline - maybe restart the gateway and that usually solves the issue.

General tip for gateways is that you need to restart it everytime you make a change to a Power BI report and publish it.

Also, if that isn't the issue, the next thing I'd do, is download the report as a pbix and then try the refresh in desktop - usually you'll get a more descriptive error message there. If your refresh works fine, then it's most likely an issue with credentials within the service or a gateway. If the refresh doesn't work, then open Power Query Editor and see which query is failing and fix it. Common reasons for the query breaking is when columns are removed or renamed in the source and you're referencing them in steps.

Hope that helps.

[blestone111]

the report refresh fine in desktop and the gateway is not offline too

[Jai-Rathinavel]

@blestone111 , are your able to download the model ? If yes, try refreshing it in desktop, look out for any errors and debug it on query level. 

[blestone111 · Accepted solution]

the report refresh fine in desktop and the gateway is not offline too

[Jai-Rathinavel]

@blestone111 , Try reconfiguring the datasource credentials on service and refresh. 

[blestone111]

Tried that too...