Data refresh through PBI Gateway keep prompting credential missing incorrectly

While using PBI Service with on-premise data gateway connecting local excel files, the refresh keeps failed with "credentialMissing" error, however all credentials has already been given and verified...

Gateways

HemantNagar

Regular Visitor

6 years ago

We had a call with Microsoft Support Engineer. He suggested that the error is due to the use of merge or append steps in the Power Query when connecting to shared folder. He provided us with the below workarounds:

Use Personal gateway
Use Gateway for each file
Try to remodel to avoid merge and append steps
Move the files to Sharepoint or Onedrive

We have not yet implemented any of the workarounds.

Completed Ideas

Set as landing page feature missing in Apr 2026 update (Build 2.153.1206.0) both in Desktop and Serv
Input Slicer Bug: Cursor jumps to position 0 and values cannot be cleared in Service
Input Slicer Causing Browser Tab Freeze in Public Links (Started April 24, 2026)
Small multiples not fitting to scale
Previously working Mac calender visual now gives me a error every time I touch it!
Text Slicer does not reset via Bookmarks or Clear All in Power BI Service (Service-only behavior)
Text Input Slicer is not reset by bookmarks in Power BI Service while working correctly in Power BI
Azure maps not displaying mapped data points in publish to web when location used
Azure Maps reference layer transparency behaves differently after publishing to Power BI Service
Desktop Application Bug?? - PBI desktop application left navigation icons always solid black