Forum Discussion
Operation returned an invalid status code 'Unauthorized' while copying data to Lakehouse
Vinodh247 Thanks for replying.
I'm trying the workarounds that you suggested
1. The connection still seems to be mandatory. Even when the Lakehouse is attached directly, Fabric asks for a connection to be created.
2. This approach works for small tables that run in a loop(can you please provide some info or document on how to refresh token using pipeline), but for large-volume tables the token expires in the middle of the extraction. We are planning to load these tables in chunks based on the date fields to avoid the issue.
Hi SivaReddy24680 ,
Thanks for reaching out to the Microsoft fabric community forum.
In addition to the valuable points suggested by Vinodh247 , Check out this point as well.
Please ensure that for the Lakehouse you are trying to copy data into, you have the correct workspace role assigned in the workspace where that Lakehouse exists. The role should be Contributor, Member, or Admin, Viewer is not sufficient for write operations.
I hope this information helps. Please do let us know if you have any further queries.
Thank you
I have the Admin role for the workspace. We are not encountering this error at the beginning of the process, it occurs intermittently after writing some records.
Hi SivaReddy24680 ,
Sorry to know it didn’t help. Please consider reaching out to Microsoft Support. You can provide them with all the troubleshooting steps you've already taken, which will help them understand the issue better and provide a resolution. They might be able to identify something specific about your admin account setup or provide a solution that isn't immediately obvious.
Below is the link to create Microsoft Support ticket:
Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn
RegardsHi SivaReddy24680
Could you please confirm if the issue has been resolved after raising a support case? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.Thank you for your understanding and assistance.