Forum Discussion
xl0911
Helper III
Helper IIIPower BI service not getting all data
Hello, I have a model that gets all the data from SQL Server. One of the PB tables is actually a Stored procedure, works fine in the PB desktop but when I upload it to the service I have missin...
ok, I understood the source of the problem.
Since it is a stored procedure that groups information from several databases, the problem was that on the PB desktop I connected to the sql server as a admin of all databases and when I connected to the service I connected as the manager of one database, so basically it was a permission issue.
xl0911Helper III
Helper IIIok, I understood the source of the problem.
Since it is a stored procedure that groups information from several databases, the problem was that on the PB desktop I connected to the sql server as a admin of all databases and when I connected to the service I connected as the manager of one database, so basically it was a permission issue.