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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors