Discrepancy between my sql database and power bi l...

Anonymous · ‎01-17-2022

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

Anonymous · ‎01-19-2022

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.

KNP · ‎01-17-2022

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/2285347

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr