Forum Discussion

Chanleakna123's avatar
Chanleakna123
Icon for Post Prodigy rankPost Prodigy
8 years ago
Solved

Painful on Data Source Exchange

Hi Team , 

i imported the data from Excel Workbook on my laptop. And now i wanna change all of my sources to Web base instead. 
How to exchange these ? I have a lots of Table need to be changed on data sources. 
I wish you can give me the best practice of how to exchange this , while i dun wanna redo each steps and do the calculation all over agaiin. 

Thanks with Regards, 

Leakna  

Data Modeling
  • Chanleakna123's avatar
    Chanleakna123
    8 years ago

     

    i had fially can exchange the source by using web and add ,null), at the back. 

4 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi Chanleakna123,

     

    You can get data from the new Excel file via web data source to retrieve the same table/sheet. Then go to the Advanced Editor, find the Power Query:

     

     

    Then you can open Advanced Editor for the table gets data from local Excel, replace the source step with the new power query in above. 

     

     

     

    Best Regards,
    Qiuyun Yu 

    • Chanleakna123's avatar
      Chanleakna123
      Icon for Post Prodigy rankPost Prodigy
      8 years ago

       

      Hi v-qiuyu-msft Here is what i had received the messages. 
      Can you assist me on this case ? 
      My file from Document Spreadsheet. 

      • Interkoubess's avatar
        Interkoubess
        Icon for Solution Sage rankSolution Sage
        8 years ago

        Hi Chanleakna123,

         

        I think your error is coming from CSV.Document...

         

        You can try an extract from scratch with your document on the web and copy the right formula...

         

        Hope it helps...