Text values visible in Power Query but shows blank in Power BI Table

[mkz81]

Hi! I'm strugling with the following issue. After loading the data from Excel and and transforming it as needed in Power Query I found that the whole column with text data shows in Power BI as blank. Any ideas how to fix it? 

Power Query:

Power BI Table: 

Thank you!

[PijushRoy · Accepted solution]

Hi @mkz81 

In Your screenshot, the Power Query table and Power BI table is not same rows

May be July 5, 2023 having null value as well in Power Query
Please check and rectify
You can share same rows for Power Query and Power BI data if not matching

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[mkz81]

Hi Pijush, thank you for the suggestion. In fact I realized that I made a mistake while joining the tables from Excel as the column titles didn't match and it was causing some issues in both Power Query and Power BI.  

[PijushRoy]

You are welcome @mkz81