Yes, you can use the "Combine & Transform Data" option in Power Query Editor to load multiple JSON objects from a single JSON file.
Here's how you can do it:
1. In Power BI Desktop, select "Get Data" from the Home tab of the ribbon.
2. Select "JSON" from the list of available data sources.
3. In the file selection dialog box, browse to and select the JSON file that contains multiple JSON objects.
4. In the Navigator dialog box, select the "Combine & Transform Data" option from the bottom of the preview pane.
5. In the Combine Files dialog box, select the "JSON" option.
6. In the JSON Options dialog box, select the appropriate options for your file, such as whether the file has a root node or not.
7. Click OK to close the dialog boxes and load the data into Power Query Editor.
Power Query Editor will then attempt to combine and transform the data from all the JSON objects in the file into a single table. You can then use the editor to perform any necessary transformations and data cleaning.
If you encounter any errors or issues during the loading process, you can try adjusting the JSON options or performing additional data transformations to resolve them.
