Change/update link to source data ( SFDC report)

[KRISH80]

Dear All,

I am using SFDC Report as input to my database. Now i need to update the link of SFDC report in my database and i don't know how can i do that. I tried going to Advanced editor and update, but there instead of report link i have this "00O4G000007uGudUAE". KIndly help.

let
    Source = Salesforce.Reports(),
    #"00O4G000007uGudUAE" = Source{[Name="00O4G000007uGudUAE"]}[Data]
in
    #"00O4G000007uGudUAE"

[zaza · Accepted solution]

If I understand correctly, you are connecting to a salseforce report within PowerBI. You would like to connect to another report. 

If so, then, make a new query and connect to the new report. Open the advanced editor and you will see the new code for the new report. Copy the code, close the editor, go to your original query and in the editor paste the copied code over the old one and hit save.