Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

monaraya
Microsoft Employee
‎02-20-2021 10:38 PM

Access Database Refresh fails with Data source Undefined Error in Power BI Service

Issue: Refresh fails for a Power BI Report that uses Access database as a Datasource

Error: Unable to connect to the data source undefined

blog imagemonaraya.JPG

Resolution Steps:

  • The User Credentials which are used to add the datasource under the Gateway and
     
     

    administrator of the machine where gateway running should be same as the username which is used while adding the datasource.

n1.PNG

n2.PNG

  • If both the user credentials are different then refresh would fail with the above error.
  • Now, to resolve this provide the read/write access to the user which is used while adding the gateway to the path C:\Users\PBIEgwService\AppData\Local\Temp should solve the problem.
  • Alternatively you can make the user (if the user is different while adding the datasource under the gateway)as an admin of the machine where gateway is running, whichever is convenient for you.

 

Author: Nithya Mallapu

Reviewer: Mounika Narayana Reddy

Comments