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 see good results with all processed records. But when I do a refresh in Power BI desktop, I only see a subset (7 miljon) without any filters using. 

Does anyone be familiar with this problem? And is the size of the view/table the problem?

 

Thanks in advance. 
Mardel

Need Help

1 Reply

  • 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