topic Re: fabric inserting code snippet is not supported on this file type in Data Engineering

fabric inserting code snippet is not supported on this file type

samedwalker50 — Wed, 29 May 2024 02:09:10 GMT

Hey EveryOne,

I am having problems reading the json files in the lakehouse after passing a json through an API.

I get this error anytime i try previewing the json file. inserting code snippet is not supported on this file type.

Any help would be deeply grateful.

Re: fabric inserting code snippet is not supported on this file type

v-cboorla-msft — Wed, 29 May 2024 08:18:50 GMT

Hi samedwalker50

Thanks for using Microsoft Fabric Community.

The error message "inserting code snippet is not supported on this file type" indicates that the preview functionality in Microsoft Fabric Lakecouse doesn't allow embedding code snippets within JSON files.

Download and View Locally: Download the JSON file from Lakecouse and open it in a text editor or JSON viewer on your local machine. These tools are specifically designed to display code and formatted data clearly.
Preview as Text: If a dedicated JSON viewer isn't available, try previewing the file as plain text. This might not provide a formatted view, but you'll still be able to see the raw JSON content.

Following are the reasons that might be encountering issues while previewing JSON files in the Microsoft Fabric lakehouse after passing data through an API.

Verify format settings: Make sure the format settings in your Data Pipeline's Copy Activity are correct. Ensure "JSON" is selected as the format type.
Check for incompatible characters: Previewing might not work if the JSON file contains special characters that the previewer can't handle. You can try opening the file in a text editor to confirm if there are any non-standard characters.
Data Pipeline configuration: If you're using a Notebook activity to transform the JSON file before saving it to the lakehouse table, double-check the code for any errors. Ensure it's properly parsing and formatting the JSON data.

Please refer this documentation for additional information : Microsoft Fabric – writing JSON data into a Lakehouse table – Random Procrastination (gosbell.com)

I hope this information helps. Please do let us know if you have any further queries.

Thank you.

Re: fabric inserting code snippet is not supported on this file type

v-cboorla-msft — Thu, 30 May 2024 16:17:05 GMT

Hi samedwalker50

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks.

Re: fabric inserting code snippet is not supported on this file type

samedwalker50 — Thu, 30 May 2024 16:31:05 GMT

Sorry for not responding quickly enough. Yes, I implemented the solution and it worked for me. Thanks for sharing. By the way I am open to helping out in projects if you its available