Analysis Services Database query not returning all rows

[willnic]

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 returned. I have a copy of the model I refreshed two weeks ago that had approximately 24 million rows. Now today when I refreshed the query/table, it is only pulling in 17 million rows (I didn't make any changes to the query). The data should have grown as I am pulling sales at the weekly level. I compared the data coming through the query to my tabular model and confirmed that it is simply cutting off, as no data exists for stores after a certain point. I have tested this out on several models and it appears the query is only pulling approximately 60-70% of the rows it should be bringing back.

Anyone having issues like this? I'm wondering if it has something to do with the latest version of Power BI Desktop. I pulled the data through PowerPivot and it returned all the rows, so the issue doesn't appear to be related to my underlying data.

[greggyb]

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

[willnic]

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]

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

[Phil_Seamark]

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

[patoduck]

I have 2014 Enterprise, having the same issue.