Forum Discussion

KRISH80's avatar
KRISH80
Icon for Helper II rankHelper II
6 years ago
Solved

Change/update link to source data ( SFDC report)

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"

Help to update datasource
  • zaza's avatar
    zaza
    6 years ago

    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.

     

     

1 Reply

  • zaza's avatar
    zaza
    Icon for Resolver III rankResolver III
    6 years ago

    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.