Can I make editions in Power Query when I do not have the database?

[JuanDeDios_Gut]

Hi community

An external consultant made a dashboard and gave us the .pbix but it is required to make some changes in the project. When I open Power Query there is an error due to I do not have the database so I would like to know if there is a way in which I can overcome this obstacle.

The simplest solution is asking him the database and connecting the project with database but I'm afraid this could take time (and deadline is soon). So, Does anyone know how I can work on Power Query meanwhile?

Thanks in advance

[ppm1 · Accepted solution]

Without access to the database, you won't be able to preview the data in the query editor. However, you can still open the Advanced Editor to modify the M code directly.

Pat