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.
Hello there,
I created a dataflow where the data source is the table view from the MySQL database. In the power query, it works and uploads fine, but when I try to refresh this dataflow it fails on the 11th minute of a refresh.
I tried to refresh this source both in pro and premium workspaces, and it does not work with both options and gives me different errors for these workspaces.
For the Pro workspace, it returns this error: Error: MySQL: Fatal error encountered during data read. Request ID: 861dd8d1-29a5-9147-7fab-cee4c8722c81 Activity ID: da5e6998-7f8e-4c16-bb2b-21a4f863d319
For the Premium, it returns the following error: Error: PipelineException: A connection attempt failed because the connected party did not properly respond after a period of time or established connection failed because connected host has failed to respond . RootActivityId = 28d0f4b9-55ad-4ca7-85c0-02b24ee17a88.Param1 = PipelineException: A connection attempt failed because the connected party did not properly respond after a period of time or established connection failed because connected host has failed to respond Request ID: 7db2c46c-b4b9-866a-e972-e8c5557afb2a.
Also, what is interesting, I created dataflow in the same workspace, where the source is the same MySQL DB as above, but it works as expected, and refreshes properly.
Can you please help on solving this issue?
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.