Forum Discussion

willnic's avatar
willnic
Advocate 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 ...
greggyb's avatar
greggyb
Resident Rockstar
10 years ago

Any reason you aren't using Live Explore with the SSAS source?

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    10 years ago

    Does that only work with the BI and Enterprise versions and not Standard SSAS?  Maybe he only has SSAS Standard?

    • patoduck's avatar
      patoduck
      Helper III
      9 years ago

      I have 2014 Enterprise, having the same issue.

  • willnic's avatar
    willnic
    Advocate 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
      Helper III
      9 years ago

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