Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
asamr
Helper I
Helper I

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
Super User

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?

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
Super User

can you show some anonymized rows from the metadata table?

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.