Import an Excel and keep data within PIBX

[Anonymous]

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

[PaulDBrown · Accepted solution]

@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”)

[Anonymous]

Thank you very much ! @PaulDBrown