Forum Discussion
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 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.
5 Replies
Any reason you aren't using Live Explore with the SSAS source?
Does that only work with the BI and Enterprise versions and not Standard SSAS? Maybe he only has SSAS Standard?
I have 2014 Enterprise, having the same issue.
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.
Same here, when refreshing randomly gets X number of rows... really freaky stuff, clueless as to where is the problem
