Forum Discussion
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 missing rows there.
I refresh the service model and upload it again and again and still with no change.
In the service itself, in the dataset I can see the missing rows...
What do I need to do with this issue ?
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.
2 Replies
xl0911ok, 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.- AllisonKennedy
Community Champion
xl0911 Can you elaborate more please on what you mean by has missing rows? You've said you can see the rows in the dataset in service, so where are they missing from? Could it be a filter/slicer/date issue?
