Forum Discussion
Mirrored database error
- Anonymous1 year ago
Turns out Parquet works fine and as documented. It gets hosed with the CSV. Maybe its formatting?
Hello Anonymous,
Thank you for reaching out to the Microsoft Fabric Forum Community and thanks to bao_phan for the helpful insights.
To add on:
The error you’re encountering “OperationNotAllowedOnThePath – BadRequest”
typically occurs when attempting to upload flat files (like CSVs) into a Mirrored Database, which is not supported. Mirrored databases are designed to sync data from external source systems (e.g., Azure SQL DB, Cosmos DB, Snowflake), and do not allow direct file uploads.
Recommended Approaches:
- If your goal is to work with flat files (like CSVs) please use a Lakehouse instead of a Mirrored DB and upload the CSV under the Files section of your Lakehouse.
- If you're trying to mirror a data source, could you please clarify what source system are you trying to mirror (e.g., Azure SQL, Snowflake)? And Are you using any specific tool or method to initiate the mirror?
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.