Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Issue with MS Access datasource

Hello,


When I refresh dataset in Power BI using enterprise gateway with MS Access datasource I got the following error message:

 

Capturar.PNG


When de user is administrator on machine where is enterprise gateway I don't have this issue.

 

What permission for user is it needed to work fine?

 

Att,

 

Tiago Sell

 

 

2 REPLIES 2
v-yulgu-msft
Employee
Employee

Hi @Anonymous ,

 

What is the error message? Could you translate it into English? Please add users into Gateway Administrator for a test.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi @v-yulgu-msft

 

Here is me error message error in English.

 

Error English.PNG

 

I added the user into Gateway Administrator but I got the same error (bellow).

 

OBS1: Enterprise Gateway and MS Access database file are in same server.

 

OBS2: User has full control permission on file.

Full Control File.PNG

OBS3: when the user is administrator on Enterprise Gateway server we don't have this issue.

 

Admin.PNG

 

Regards,

 

Tiago Sell

 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors