Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Fatal error encoutered during data read - But only 1 column?

Dear community!


I am so frustrated. I am getting the following error.

Ive read through SOOOO many post regarding this issue about some weird errors in some columns.

I cant simply find any errors.


Code: ttfqnY1


Error:  KHPvGvV








    Source = MySQL.Database("", "work", [ReturnSingleDatabase=true]),
    work_metadata = Source{[Schema="work",Item="metadata"]}[Data],
    #"Filtered Rows" = Table.SelectRows(work_metadata, each ([type] = "personal_info") and ([name] = "permission_club")),
    #"Added Custom" = Table.AddColumn(#"Filtered Rows", "Custom", each 1),
    #"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Custom"})
    #"Removed Other Columns"







Ive done my filtrering and afterwards I just made a column with a "1" in it.

Ive afterwards remove every column besides the "1" in it.



Is there any good explaination for this? Ive run out of ideas 😞


Thank you!

Community Support
Community Support

Hi @asamr ,


According to your question, here is a similar error that has been resolved for reference.Refresh error - MySQL: Fatal error encountered dur... - Microsoft Power BI Community


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


I have given all the information I can. My connector is not the issue.

I am receiving data from 5-6 others tables from the same database. I went with a different solution. But above is not the answer.

Super User III
Super User III

i wonder if the country='*' is tripping up the processing somewhere.  Shouldn't really be the case as wildcards are % and _  but you never know... Can you try without the country column?

Frequent Visitor

Hello again 


I am not even loading that column If you look at the code. 


#"Added Custom" = Table.AddColumn(#"Filtered Rows", "Custom", each 1),

    #"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Custom"})


    #"Removed Other Columns"


I am only loading 291.000 rows with one column with 1 in them. 

Super User III
Super User III

can you show some anonymized rows from the metadata table?

Frequent Visitor

Hi @lbendlin 


Thank you so much for responding, I can show you everything. 🙂


Here is 10 rows of data.




type = 'personal_info'
AND name = 'permission_club'





SQL Data 

SQL Types 


Here is the Data in PowerBI Editor before any filtering.


Power BI Editor 


Sidenote: I was able to pull everything out through SQL Workbench, download it as CSV, and upload to Power BI without a problem, so I really cant figure out the issue - It feels like ive tried everything. 
Hope to hear from you soon.

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Kudoed Authors