Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |