Forum Discussion
AWS S3 shortcut issue
Hi Srisakthi,
When you create a shortcut in Fabric, all the files in that folder need to follow the same structure for example, same delimiter and schema. Since some of your files are pipe-delimited and some are comma-delimited, Fabric is treating them as different formats, which is why the shortcut isn’t applying at the root level.For this scenario, the recommendation is to make sure the files are standardized before creating the shortcut same delimiter and structure. Once the files are uniform, you should be able to create the shortcut at the folder level without drilling down into each file.
Kindly refer to the below documentation links for better understanding:
https://learn.microsoft.com/en-us/fabric/onelake/shortcuts-file-transformations/transformations
https://learn.microsoft.com/en-us/fabric/onelake/create-onelake-shortcut
https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcutsHope this helps if you have any queries we are happy to assist you further.
Best Regards,
Harshitha.
Hi Srisakthi,
Thank you for reaching out to the Microsoft fabric community forum.
Just to understand better, are you facing this issue while connecting to your AWS S3 data through Power BI or when working with Microsoft Fabric? This will help us guide you with the right steps.
Best Regards,
Harshitha.
Hi Srisakthi,
When you create a shortcut in Fabric, all the files in that folder need to follow the same structure for example, same delimiter and schema. Since some of your files are pipe-delimited and some are comma-delimited, Fabric is treating them as different formats, which is why the shortcut isn’t applying at the root level.For this scenario, the recommendation is to make sure the files are standardized before creating the shortcut same delimiter and structure. Once the files are uniform, you should be able to create the shortcut at the folder level without drilling down into each file.
Kindly refer to the below documentation links for better understanding:
https://learn.microsoft.com/en-us/fabric/onelake/shortcuts-file-transformations/transformations
https://learn.microsoft.com/en-us/fabric/onelake/create-onelake-shortcut
https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcutsHope this helps if you have any queries we are happy to assist you further.
Best Regards,
Harshitha.Hi Srisakthi,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Regards,
Community Support Team.
