Forum Discussion

sunnyleung's avatar
sunnyleung
Advocate I
6 years ago

Credential Missing

I got the below error while refreshing the dataset through on-premise data gateway   Last refresh failed: Wed Aug 12 2020 16:24:28 GMT+0800 (Hong Kong Standard Time) Invalid connection credentials...
Need Help
OB's avatar
OB
Helper II
6 years ago

We've had the same or at least very similar issue since the beginning of last week: error when refrehing in PBI Service, but no issues in PBI Desktop.

 

This affected two reports, one that uses SharePoint Lists on prem, the other one that uses files stored in SharePoint on prem (Gateway set as Web).  Both reports use Append in Power Query.  The latter report could be fixed by recreating the Append table again from scratch in a new report.  The former (SharePoint lists) refreshes fine if the sources are NOT appended, but fails to refresh when an Append table is created in Power Query (no issues when using Union in DAX). 

 

The error includes reference to DM_GWPipeline_Gateway_InvalidConnectionCredentials although the gateway connection gives no errors.

It also includes reference to Microsoft.Data.Mashup.CredentialError.DataSourceKind", so that's why we went to test and found out that the Append table is the reason of failing refresh.

  • OB's avatar
    OB
    Helper II
    5 years ago

    We had June 2020 gateway when the issue happened in the beginning of August 2020, then upgraded the gateway to the latest availalbe at that time = July 2020, then later in the month to August 2020 and the issue remained. 

     

    We found another temporary workaround - check it here:

    https://community.powerbi.com/t5/Service/DM-GWPipeline-Gateway-MashupDataAccessError-On-Premises-Data/m-p/1375145#M108798

     

    But I should say that the original report that failed to refresh with appended tables has been successfully refreshing since September 1, 2020 again without any changes on our side.