Moving list location without redo the report?

[Anonymous]

Hello everyone, I am using power bi with my dataset which is a sharepoint list. I load my data, i format it with power query and i create my report and everything works.

But if i change my list location, and i download it a new time from another location, i have to format it new time.

Is there a skill to move my list everywhere without having to redo all the manipulations please ?

Thanks and Have a good day !

[v-lili6-msft · Accepted solution]

HI  @Anonymous 

For normal, you could download the pbix file, then open the power qyuery and chenge the source path in right pane as below:

Then publish it to service again.

and for your case, you could also save a pbit file to get it as below:

See more details as below:

https://www.datavizioner.com/blog/how-to-use-power-bi-documenter/

https://www.powerbitutorial.org/tutorials/power-bi-templates/

also, you could have a try parameter in power bi too

 https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

https://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-parameters-in-power-bi-desktop-part-4/

Regards,

Lin