Forum Discussion

Saurabhuu's avatar
Saurabhuu
Frequent Visitor
2 years ago

Getting different results with the same querry

In data wearhouse when iam fetching the data we are getting 11 records with the distinct values and these tables are connected to ssas using azure pipelines and then cubes are created and these cubes are connected to powerbi with live connection then iam applying the same filter in tabluer model but here iam getting different that is 14 records

What might be the issue.can any one help me regarding this..

Tips and Tricks

2 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    Hi Saurabhuu -In your etl process, azure pipelines, transformations or filters might have been applied incorrectly or inconsistently.Inspect the Azure pipeline steps to ensure transformations and filters are consistent and correct.Verify the data loaded into the SSAS Tabular model matches the data in the data warehouse also check the filters applied in Power BI are identical to those used in the data warehouse query. Cross-check every filter condition.

    There might be duplicate records introduced during the ETL process or in the Tabular model.

     

    Hope it helps

     

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,

    Thanks for the solution rajendraongole1  offered, and i want to offer some more information for user to refer to.

    hello Saurabhuu , based on your description, please check that if the refresh of tha data source has done without error.

    And your data source is SSAS, you can use the SQL Server profiler to track the query  to see the difference between the query.

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.