Forum Discussion
Solved
Service not refreshing/loading a specific field
Hi everyone, I want to create an overview of all views and stored procedures in PowerBI with the query below. This works fine in Power BI desktop, but when you refresh the data in Power BI servic...
I think GilbertQ is on to something regarding permissions.
To see definitions in sys.sql_modules a user needs to be granted VIEW DEFINITION in sql server. In your case you'd want to do that at schema level at least for the account running the gateway.
I think GilbertQ is on to something regarding permissions.
To see definitions in sys.sql_modules a user needs to be granted VIEW DEFINITION in sql server. In your case you'd want to do that at schema level at least for the account running the gateway.
That's it indeed!
In my case I went to the properties of the SQL Server user >> Securables >> Permission >> "View any definition".
Thanks bcdobbs and GilbertQ!