Export to Data Lake - Server returned non-success HTTP response: Forbidden

(1) Share

Report

Posted on by WSS

Trying add a new table to to the export to Data Lake in FnO. I'm getting:

We found errors in tables Locations while exporting data. See the error codes for details in few minutes.

Server returned non-success HTTP response: Forbidden

I'm not sure exactly how I would go about fixing this or getting further diagnostic Info.?

Any Ideas anyone?

All responses (5)

Answers (1)

WSS 40 on at

Like (0)

Report

Export to Data Lake - Server returned non-success HTTP response: Forbidden

Yea it was too many active tables from memory.
Suggested answer

Community member 2 on at

Like (0)

Report

Export to Data Lake - Server returned non-success HTTP response: Forbidden

Hello,

I had the same problem, and eventually, I managed to solve it!

Synapse is limited to 350 active tables. You need to disable some before attempting to export!
Verified answer

Community member 11 on at

Like (2)

Report

Export to Data Lake - Server returned non-success HTTP response: Forbidden

Count up the number of tables you are able to export: do they total 350?
Export to Data Lake has a hard limit of 350 tables. Any more than that and you probably want to use Synapse.
WSS 40 on at

Like (0)

Report

RE: Export to Data Lake - Server returned non-success HTTP response: Forbidden

No I don't think I got anywhere with this sorry
EdipT 5 on at

Like (0)

Report

RE: Export to Data Lake - Server returned non-success HTTP response: Forbidden

Hi WSS, I am facing the same problem. were you able to solve this? if yes please could you share?