Forum Discussion
Data preview filled/available in Power Query but empty table in PowerBI
Hi all, I'm working on a PowerBI project where I pull data from a MySQL database and am trying to get it in a format where I can use it to create graphs. The import works fine and I've edited a n...
So, I had a similar issue:
1. I peform a merge and it was successful. The expanded columns had no blank rows in the Power Query view; I even tried to filter the rows for empty values, yet no results came up. Everything was filled in;
2. After closing & loading the data, I was surprised to find out that the expected columns did contain blank rows, which was messing up my project.
The solution which worked for me was in this thread:
Hope it will help you as well!