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.
Hi all,
When using a MySQL dataset within PowerBI that contains a UUID with a foreign key, I get the following error:
Non-negative number required. Parameter name: count
Is there any fixes for this both PowerBI side or MySQL?
Hi, @Anonymous
According to my research, the order of the Appended Queries in the Power query seem to be possible to cause this kind of problem. Have you done any operations in the Power query?
If not, the problem should exist on the MySQL side, the large dataset can also be the possible reason, you can refer to these links:
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Robert,
Appreciate the reply! The dataset sadly is very small, 300 rows to be exact roughly speaking. I'm still new to PowerBI, and I have solely just created a new report and added the database (please see below reply where I show screenshot of such).
@Anonymous , do have any field count? or any parameter you have created?
I don't, which is very odd..
I literally create a new PowerBI document, add my MySQL data source and select one of my tables that contains the foreign key
This is a fresh PowerBI document
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |