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!
Do all users need to be gateway administrators to be able to use the gateway datasources?
Me and another user shares a .pbix file. It is on a shared drive and should be identical datasource wise.
I can publish the project to the service without problem, but when the other user publishes we get an error that the dataset can not find the gateway.
The other account is a user for the datasource in the gateway, but not a gateway administrator. Does it have to be?
(Edit)
It is configured for scheduled import mode.
Solved! Go to Solution.
The other user was in a different (older) version of Power BI Desktop.
Updated to the oktober release and now it works.
@Anonymous,
The user doesn't have to be gateway administrator, after you add him as user of the data source in gateway, he can use the data source to refresh Power BI report.
In your scenario, please make sure that if the user uses same connection string as yours to connect to the data source, and if the users adds data sources in the PBIX file.
By the way, what is the data source?
Regards,
Lydia
The other user was in a different (older) version of Power BI Desktop.
Updated to the oktober release and now it works.
The source is a SQL database.
We both connect with server and database name using windows auth.
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.