Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Import an Excel and keep data within PIBX

hi guys ,

 

Is there a way to import an Excel into PIBX and keep it in the PIBX without requiring its connection to update later. 

 

In fact, I have  imported an Excel into my PIBX and sent it to a collegue. This one can not make the data refresh of all tables because the PIBX doesn't find the connection to the Excel file imported. Thus, I would like to import data of an Excel sheet into the PIBX without having to create a connection. 

 

Is it possible ?

 

Thank you

  • Anonymous
    You can disable data source refresh by selecting the table in Power Query and right-clicking to access the options for that table (uncheck “include in refresh”)

2 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    Anonymous
    You can disable data source refresh by selecting the table in Power Query and right-clicking to access the options for that table (uncheck “include in refresh”)