Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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:
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:
Does anyone have any idea why this could be happening?
Cheers,
Niall
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!
Hi, has there been a solution to this problem? I have exactly the same. Thanks
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.
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.
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
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
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
29 | |
12 | |
12 | |
11 | |
8 |
User | Count |
---|---|
53 | |
27 | |
15 | |
14 | |
13 |