Can an Excel file using Power Query run under parallels?

[SteveG31]

Hi,
trying to understand how I can get a solution to this problem:

• I generated a number of json files (from MS Graph queries) and stored them on my MacBook.
• Created an Excel workbook in the same folder as the .json files.
• Use the Excel Power Query tool to load the json data into excel tables
• Create a dashboard using that data.

This all works for me locally using Mac OS.
I want to be able to share this Exce - at least the loaded data and dashboard to other Windows and Mac users.

As a first step, I tried to open the workbook using Excel for Windows under parallels.

The Power Query refresh fails on the first line because the file is not found:
= Json.Document(File.Contents("/Users/steve/Library/CloudStorage/OneDrive-SharedLibraries-SRO/IT Team - Documents/General/operations/UserReports2/exports/securitygroupmembers-SROLondon.json"))
If I browse for the file again the query changes to:
= Json.Document(File.Contents("\\Mac\Home\Library\CloudStorage\OneDrive-SharedLibraries-SRO\IT Team - Documents\General\operations\UserReports2\exports\securitygroupmembers-SROLondon.json"))

Then the updated query is no longer valid on macOS.

Is there anywhere I can store the json files, so that the source file name will be the same when running Excel Mac and Excel Windows?