Data preview filled/available in Power Query but empty table in PowerBI

[greyniall]

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 number of tables to:

1. Remove some columns (Table.SelectRows)
2. Expand tables using table names (Table.ExpandTableColumn) (using Pete's suggestion posted here)

After this, I get a nice table in Power Query editor with data from multiple tables (with table names in the first column). All good so far, see below

But next, if I Apply and close Power Query and look at the tables using the Data tab, the table is completely empty. 

What I've tried and which has not given me any different result:

1. Removing spaces from the table names
2. Changing the order of the queries
3. Turning off parallel loading of tables
4. Restart PowerBI/PC and clearing cache/permissions

Does anyone have any idea why this could be happening? 

Cheers,

Niall

[DianaMF]

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!

[unkown]

Hi, has there been a solution to this problem? I have exactly the same. Thanks 

[greyniall]

Hi, I can confirm it has not been solved. I went through the lengthly process of creating a ticket, having mulitiple Teams sessions with support persons to show them repeatedly why it did not work. After this, they came back with solutions which did not provide the same functionality. Finally the bug was confirmed and it was put on the backlog. My ticket was closed as "solved"... They promised to keep me up to date on the progress but nothing so far. It was all a bit dissapointing to be honest. 

My advice: spend your time on what you can (hopefully) control: a different way of structuring your source data or retrieving it in another way, and not on Microsoft support. 

[AnkitKukreja]

Hi! @greyniall 

Please test this with another source. If the issue persists, please upgrade to the latest version if not done yet. If this doesn't help please raise a ticket to MS.

[greyniall]

Hi @AnkitKukreja 

Thanks for your help. I tried the exact same method using an Excel file and the result is identical: only 2 empty records. I'm using the latest version I believe: 2.108.603.0 64-bit (August 2022). I can't really imagine that this is the first time that someone has come across this issue but I will raise a ticket nonetheless. 

Just to be sure, do you mean posting theissue here: https://community.powerbi.com/t5/Issues/idb-p/Issues

or do you mean through the Office 365 admin portal? I am not an IT admin unfortunately. 

If anyone else has any ideas, I'm all ears!

Cheers,

Graham

[v-jingzhang]

Hi @greyniall 

You can raise a support ticket at Support | Microsoft Power BI. This blog will guide you: How to create a support ticket in Power BI - Microsoft Power BI Community

Best Regards,
Community Support Team _ Jing

[AnkitKukreja]

Hi! @greyniall 

I haven't seen this issue earlier. But, it would be good to know the solution once you are able to solve this. Please ask your organization Admin to raise a ticket on your behalf from the O365 Admin portal.