cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kakirr
Microsoft
Microsoft

Bi permissions error after configuring gateway (in standard mode)

After setting up a Gateway in standard mode, we are encountering an error with Bi re: permissions. No one I have spoken to in Bi has seen this same error before. We have confirmed all data sources are properly connected so this issue is the only one preventing us from refreshing our reports. The error message is as follows:

You do not have privileges to perform this operation.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.

1 ACCEPTED SOLUTION

Hi Team,

 

The issue was with the permissions within the query editor; in addition to the dataset settings, I also need to resolve all table permissions within the query editor. I almost have the table permissions resolved using my creds for each data source. Thank you for your help.

View solution in original post

3 REPLIES 3
v-shex-msft
Community Support
Community Support

HI @kakirr,

Can you please share more detail information to help us clarify your scenario? It will help with troubleshooting your issues.

Troubleshoot gateways - Power BI#refresh-history 

What type of device did you host the power bi gateway? Can you confirm these gateway client has configured/installed by the user account who has corresponding operation permissions on your device? Any specific firewall rules or network policy enabled that may block the gateway client requests?

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi Team,

 

The issue was with the permissions within the query editor; in addition to the dataset settings, I also need to resolve all table permissions within the query editor. I almost have the table permissions resolved using my creds for each data source. Thank you for your help.

FarhanAhmed
Super User
Super User

Is this an update or new installation of gateway ?

Are you able to test all datasources after installation of this gateway ?

Is Power BI Gateway user has some permission revoked ?







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




Helpful resources

Announcements
Power BI Show Ep 4 Post Show Carousel.jpg

The Power BI Community Show

Shabnam Watson demos Incremental refresh & Hybrid Tables and Leila Etaati demos Charticulator.

PBI April Release 2022 768x460.png

Check it out!

Click here to read more about the April 2022 updates!

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors