Forum Discussion

willnic's avatar
willnic
Icon for Advocate II rankAdvocate II
10 years ago

Analysis Services Database query not returning all rows

I have models where I am dumping data from a tabular model using the Get Data > SSAS Database functionality. Recently (sometime over the last two weeks) the query editor started cutting off the rows ...
willnic's avatar
willnic
Icon for Advocate II rankAdvocate II
10 years ago

I am dumping data into Power BI in order to manage permissions so users only see a filtered version of the data, not the full dataset. We don't have permissions on our full tabular model, so by dumping I can filter in PowerBI edit query to only one region for which certain users should access.

patoduck's avatar
patoduck
Icon for Helper III rankHelper III
9 years ago

Same here, when refreshing randomly gets X number of rows... really freaky stuff, clueless as to where is the problem