Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Discrepancy between my sql database and power bi loaded data

Hi,

 

I have around 33750 rows in my sql database but in power bi if i load the table i get only 31710 line items, especially in the year 2022 i am not getting the data. Can some one advise the reason behind the set back.

 

I tried loading using My SQL query as well as tables, getting same result

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    Can you please share more detail information to help us clarify your scenario? For example:

     

    1. Did you use Import or Direct Query mode?

    2. Did you do some advanced filter before loading data?

     

    3. Did you merge tables or do some transformation like remove errors/ remove rows...

     

     

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