You can disable privacy level controls, please make sure that this is in accordance with your organisation policy.
To do so you can follow those steps:
Go to Power Query settings
In the Global options go to privacy section in the left panel
Check the "Always ignore Privacy Level settings" box and click on Ok
Refresh your data in Power Query
Save and apply