Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Copy data from excel into BI

Hi,

i want to copy more than 3000 cells into a power bi table.

 

How can i do that?

Is there a way to connect data (Data > Excel) and then leave data static in?

 

Thanks

Need Help
  • Thim's avatar
    Thim
    7 years ago

    After you have imported the Excel spreadsheet, then click on "Edit Queries".

    From there, right click on the excel spreadsheet, and remove the check that says "Include in report refresh"

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     


    This should change the excel data to static data.

     

9 Replies

  • Thim's avatar
    Thim
    Resolver V
    7 years ago

    After you have imported the Excel spreadsheet, then click on "Edit Queries".

    From there, right click on the excel spreadsheet, and remove the check that says "Include in report refresh"

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     


    This should change the excel data to static data.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      already done, nothing change

       

      If a delete excel file power bi stop works

      • Thim's avatar
        Thim
        Resolver V
        7 years ago

        You are sure, the field is unchecked?

         

        I have just tested it from here, and my BI report is still functional after i have deleted the Excel File.

    • Moehimby's avatar
      Moehimby
      Helper III
      1 year ago

      This doesn't seem to work anymore, I keep getting errors that other queries are failing because the source document is unavailable despite "Include in report refresh" definitely being unchecked.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi, 

    I'm not sure I understand your problem could you develop ?

     

    Using Get Data>Excel does not get you what you want ?

    Regards, 

    Etienne

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      No cause if you delete or move excel file BI doesn't work

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi, 

     

    I am having the same problem, I have a static table that I require (more than 3000 cells) but even when I mark the table to not be included in the refresh it still fails. 

     

    Any suggestions?