Forum Discussion

asamr's avatar
asamr
Helper I
5 years ago

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: 

 

Error:  

 

 

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!

Need Help

6 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    can you show some anonymized rows from the metadata table?

    • asamr's avatar
      asamr
      Helper I
      5 years ago

      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.

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    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's avatar
      asamr
      Helper I
      5 years ago

      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. 

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    5 years ago

    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.

     

    • asamr's avatar
      asamr
      Helper I
      5 years ago

      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.