Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Export to Power BI exist with 429 HTTP error code #10

Open
pyToshka opened this issue Sep 29, 2023 · 0 comments
Open

Export to Power BI exist with 429 HTTP error code #10

pyToshka opened this issue Sep 29, 2023 · 0 comments

Comments

@pyToshka
Copy link

pyToshka commented Sep 29, 2023

Hello, I attempted to export a dataset containing approximately 2,000 records to PowerBI. Regrettably, the export was unsuccessful, and it appears that PowerBI has restricted the export, possibly due to limitations on my REST API requests.
I tried to push random sample for 100 records, it's worked as expected
Does anyone have advice on how I can address this issue?

10:05:05] [INFO] [dku.block.link.interaction]  - Check result for nullity exceptionIfNull=true result=null
[10:05:05] [INFO] [dku.utils]  - Traceback (most recent call last):
[10:05:05] [INFO] [dku.utils]  -   File "/home/dataiku/dataiku-dss-11.3.1/python/dataiku/exporter/server.py", line 106, in serve
[10:05:05] [INFO] [dku.utils]  -     row_count = export_rows(exporter, command["exportBehavior"], command["schema"], input, command.get("destinationFilePath", None))
[10:05:05] [INFO] [dku.utils]  -   File "/home/dataiku/dataiku-dss-11.3.1/python/dataiku/exporter/server.py", line 65, in export_rows
[10:05:05] [INFO] [dku.utils]  -     exporter.write_row(tuple(clean_row))
[10:05:05] [INFO] [dku.utils]  -   File "/tmp/tmp_folder_UmWMECVA/dku_code.py", line 131, in write_row
[10:05:05] [INFO] [dku.utils]  -   File "/home/dataiku/dss/plugins/dev/microsoft-power-bi-v2/python-lib/powerbi.py", line 191, in post_table_row
[10:05:05] [INFO] [dku.utils]  -     fail_on_errors=True
[10:05:05] [INFO] [dku.utils]  -   File "/home/dataiku/dss/plugins/dev/microsoft-power-bi-v2/python-lib/powerbi.py", line 165, in post
[10:05:05] [INFO] [dku.utils]  -     assert_response_ok(response, fail_on_errors=fail_on_errors)
[10:05:05] [INFO] [dku.utils]  -   File "/home/dataiku/dss/plugins/dev/microsoft-power-bi-v2/python-lib/powerbi.py", line 232, in assert_response_ok
[10:05:05] [INFO] [dku.utils]  -     handle_exception_message(error_message, fail_on_errors=fail_on_errors)
[10:05:05] [INFO] [dku.utils]  -   File "/home/dataiku/dss/plugins/dev/microsoft-power-bi-v2/python-lib/powerbi.py", line 237, in handle_exception_message
[10:05:05] [INFO] [dku.utils]  -     raise Exception(message)
[10:05:05] [INFO] [dku.utils]  - Exception: Error 429: b'{"Message":"Request is blocked by the upstream service until: 9/29/2023 10:05:37 AM"}'
[10:05:05] [INFO] [dku.utils]  - 2023-09-29 10:05:05,770 INFO Client closed
[10:05:05] [INFO] [dku.kernels]  - Process done with code 0
[10:05:05] [INFO] [dku.kernels]  - Getting kernel tail
[10:05:05] [INFO] [dku.kernels]  - Trying to enrich exception: com.dataiku.dip.io.SocketBlockLinkKernelException: Failed to export rows : <class 'Exception'> : Error 429: b'{"Message":"Request is blocked by the upstream service until: 9/29/2023 10:05:37 AM"}' from kernel com.dataiku.dip.export.CustomExporterPythonKernel@5a832484 process=null pid=?? retcode=0
[10:05:05] [INFO] [dip.pyexporter.output]  - Cleaning up python worker
[10:05:05] [INFO] [dku.block.link]  - Closed socket
[10:05:05] [INFO] [dku.block.link]  - Closed socket
[10:05:05] [INFO] [dku.block.link]  - Closed serverSocket
[10:05:08] [ERROR] [dku.export.thread.local] - Export failed
com.dataiku.dip.io.SocketBlockLinkKernelException: Failed to export rows : <class 'Exception'> : Error 429: b'{"Message":"Request is blocked by the upstream service until: 9/29/2023 10:05:37 AM"}'
	at com.dataiku.dip.io.SocketBlockLinkInteraction.throwExceptionFromPython(SocketBlockLinkInteraction.java:302)
	at com.dataiku.dip.io.SocketBlockLinkInteraction$AsyncResult.checkException(SocketBlockLinkInteraction.java:215)
	at com.dataiku.dip.io.SocketBlockLinkInteraction$AsyncResult.get(SocketBlockLinkInteraction.java:190)
	at com.dataiku.dip.io.SingleCommandKernelLink$1.call(SingleCommandKernelLink.java:211)
	at com.dataiku.dip.export.output.CustomPythonExportOutput.stream(CustomPythonExportOutput.java:115)
	at com.dataiku.dip.export.LocalExportFutureThread$OutputThread.run(LocalExportFutureThread.java:200)
[10:05:08] [INFO] [dku.export.thread.local] - End of export thread [admin_YOOkUs3] status=FAILED
[10:05:08] [INFO] [dku.flow.activity] - Run thread failed for activity compute_ybfg0cPz_NP
com.dataiku.dip.io.SocketBlockLinkKernelException: Failed to export rows : <class 'Exception'> : Error 429: b'{"Message":"Request is blocked by the upstream service until: 9/29/2023 10:05:37 AM"}'
	at com.dataiku.dip.io.SocketBlockLinkInteraction.throwExceptionFromPython(SocketBlockLinkInteraction.java:302)
	at com.dataiku.dip.io.SocketBlockLinkInteraction$AsyncResult.checkException(SocketBlockLinkInteraction.java:215)
	at com.dataiku.dip.io.SocketBlockLinkInteraction$AsyncResult.get(SocketBlockLinkInteraction.java:190)
	at com.dataiku.dip.io.SingleCommandKernelLink$1.call(SingleCommandKernelLink.java:211)
	at com.dataiku.dip.export.output.CustomPythonExportOutput.stream(CustomPythonExportOutput.java:115)
	at com.dataiku.dip.export.LocalExportFutureThread$OutputThread.run(LocalExportFutureThread.java:200)
[10:05:08] [INFO] [dku.flow.activity] running compute_ybfg0cPz_NP - activity is finished
[10:05:08] [ERROR] [dku.flow.activity] running compute_ybfg0cPz_NP - Activity failed
com.dataiku.dip.io.SocketBlockLinkKernelException: Failed to export rows : <class 'Exception'> : Error 429: b'{"Message":"Request is blocked by the upstream service until: 9/29/2023 10:05:37 AM"}'
	at com.dataiku.dip.io.SocketBlockLinkInteraction.throwExceptionFromPython(SocketBlockLinkInteraction.java:302)
	at com.dataiku.dip.io.SocketBlockLinkInteraction$AsyncResult.checkException(SocketBlockLinkInteraction.java:215)
	at com.dataiku.dip.io.SocketBlockLinkInteraction$AsyncResult.get(SocketBlockLinkInteraction.java:190)
	at com.dataiku.dip.io.SingleCommandKernelLink$1.call(SingleCommandKernelLink.java:211)
	at com.dataiku.dip.export.output.CustomPythonExportOutput.stream(CustomPythonExportOutput.java:115)
	at com.dataiku.dip.export.LocalExportFutureThread$OutputThread.run(LocalExportFutureThread.java:200)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant