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.

View solution in original post

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 December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!