Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Not all data visible in Power BI report from data source SSAS table view

Goodmorning, We are having a datamodel in SSAS tabluar and using view tables from the database. Now I am using a view from a big table (30 miljon records). When I process at the backend in SSMS, I...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Thanks for reaching out to us with your problem. Based on your description, it seems that the amount of data displayed in Power BI does not match the amount of data displayed in the SSAS table when data is loaded from the SSAS model into Power BI. In order to better understand your problem and give you a suitable solution, could you please provide the following information?

SSAS side:

Please check and confirm if process the data successfully in SSAS?

powerquery - SSAS Tabular - Power Query Editor stuck at "Operation in progress" - "identifying schemas"

Power BI side:

1. What kind of connection mode are you using to connect to the SSAS model?
2. Where are you viewing the data in Power BI? Is it inside Power Query Editor, or is the data display in some visual you created? If you created a visual,how did you set it up?
3. Did you apply any filters or slicers in the report?

4. Check if it hit any limitation?

Best Regards