Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Im trying out the new Datamart and going to connect to a SQL server database through a onprem powerbi gateway. When creating a flow it workes fine, but on with datamart I get the error permission error.
An exception occurred: You do not have permissions for the on-premises data gateway. Please request permissions from the owner of the gateway. (Session ID: eba0033d-61cc-458b-b4cc-dccc207f672f, Region: europe)
Is there any limitations or settting our admin need to enable to get it working?
Solved! Go to Solution.
Hi @Stake
Yes it appears that you need to ask your Power BI Gateway Admin to make sure you have got the permissions to view and execute via the data source.
You can view them here:
New data source and gateway management experience | Microsoft Power BI Blog | Microsoft Power BI
Hi @GilbertQ , can you elaborate where "permissions to view and execute via the data source" are granted on a data source in the gateway? Thanks.
Hi @GilbertQ thanks for that. When you say "view and execute" do you mean just assign the user the permissions on the gateway. I was literally looking for something specific that says "View" and "Execute". Thanks.
Yeah sorry I mean just grant access to the data source on the gateway.
Thank you!
Hi @Stake
Yes it appears that you need to ask your Power BI Gateway Admin to make sure you have got the permissions to view and execute via the data source.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.