Data not showing in data view for certain criteria

joeyrobbins · ‎09-28-2022

Hi,

I have a data source with couriers and a 'Final price' in a table. On query editor, everything shows perfectly fine, however on the data view tab (and visualisations), the data in just 1 column for just 1 of my couriers (GLS) pulls through as blank. For every other courier, this final price pulls through fine! 3 images are attached showing this.

What can be possibly affecting this between the power query, and the data view tab? I'm completely lost!

Many thanks

Joey

parry2k · ‎09-28-2022

@joeyrobbins weird, can you refresh the data and then test it?

✨ Follow us on LinkedIn and to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.