Data Source error for pulling MySQL data into Power Query

Power Query
1

Hello,

I need guidance on what steps to follow to resolve following data source error while importing data from MySQL into Power Query:

“Guid should contain 32 digits with 4 dashes…”

Please find attached screenshot of the error.

image1
image11910×652 54.6 KB

Thanks in advance!

-Prutha Shah

2

.

Can you see if adding the OldGuids parameter to the options record resolves this.

  • OldGuids : A logical (true/false) that sets whether char(36) columns (if false) or binary(16) columns (if true) will be treated as GUIDs. The default value is false.

= MySQL.Database(“servername”, “databasename”, [OldGuids=true])

.
Here’s a link to the documentation.

4

Wouldn’t know I’m afraid, let’s hope someone else can chime in…

Otherwise you should (have a Power BI administrator with in your tennant) create a support ticket in the Power BI admin portal so Microsoft can look into it.

5

Thank You Melissa, for all your help. I really appreciate it. The client’s IT team is looking into it, as of now.

1 Like