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,
I have created a dashboard with source 'IBM DB2 database'. I have 5 tables related as shown in the screenshot.
The tables contains data in millions,
Tables | Data |
Table 1- | 19 M |
Table 2- | 7 M |
Table 3- | 10 M |
Table 4- | 3 M |
Table 5- | 132 |
The report is published to Power BI service. we are using On premises gateway to schedule a refresh but it is getting failed after running for around 2 hours. The time out duration is also given as 5 hours in the data source.
The same data is getting refreshed when we try it from the Power BI desktop. It is throwing below 'Time out error'
Data source error: | {"error":{"code":"DM_GWPipeline_Gateway_TimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_TimeoutError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: Table 1. |
I have tried everything, but the error still persists.
Looking forward for any answers.
Thank you in advance !
Tanvi
Hi @TanviChourasia ,
Check the reference below:
https://docs.microsoft.com/en-us/powerquery-m/db2-database
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi,
I'm also facing the same 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.