Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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.
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.
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'
;
Here is the Data in PowerBI Editor before any filtering.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |