cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
asamr
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

 

 

Code:

 

 

 

 

let
    Source = MySQL.Database("work-bi.ciyrl270twbn.eu-west-1.rds.amazonaws.com", "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"})
in
    #"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.

 

IT STILL FAILED?

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

 

Thank you!

6 REPLIES 6
v-henryk-mstf
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,
Henry


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.

lbendlin
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?

asamr
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"})

in

    #"Removed Other Columns"

 

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

lbendlin
Super User III
Super User III

can you show some anonymized rows from the metadata table?

asamr
Frequent Visitor

Hi @lbendlin 

 

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

 

Here is 10 rows of data.

 

 

 

SELECT
*
FROM
work.metadata
WHERE
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

Announcements
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!

secondImage

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