Refreshing Data

[Anonymous]

Hi guys, 

Would it be possible to refresh data from a different excel files sheet ?

The thing is I've created a table under PBI Desktop for a specific excel file (X) and has download others data under another excel file (Y) which has the same configuration (columns configuration identical than X file).  

Looking forward your answers,

Thanks

[v-shex-msft]

Hi @Anonymous,

Did you mean your datasource who has configured by other excel sheet?(Such as connect string are stored in one excel sheet, so you need to get data from this file first and use stored parameter to connect data from another data source)

If this is a case, it is possible.  You only need to create custom steps to store analytics parameters, then write a custom step with 'access data functions' to get data from another datasource based on these parameters.

Regards,

Xiaoxin Sheng