Scheduled upgrade of dynamic databases

[Syndicate_Admin]

Good morning

To create my databases I am using some functions and this does not allow me to perform a scheduled update.

If with the function I use an entire directory, it works, but the moment I use a parameter for the function, it does not allow me.

I can't put the entire directory because if not, the modifications I need the function to do are done incorrectly.

Any ideas?

Thank you.

[Syndicate_Admin]

Being combining different Excel from which I need to transpose the imported tables, I can not get it directly from the folder, I need to perform a function.

Is there no way to be able to perform scheduled updates using these functions for loading data from folders?

[Syndicate_Admin]

Thanks a lot

The examples I see are with Web.Contents and I need to use it with File.Contents and it gives me error:

let

Origen = Excel.Workbook(File.Contents("\\Desktop\" ,[RelativePath = Anio]

), null, true)
in Origen

the error that appears to me is:

DataSource.Error: File.Contents: This function does not support the "RelativePath" query option with value ""2022.xlsx"".
Details:
2022.xlsx

[v-chenwuz-msft]

Hi @Syndicate_Admin ,

Is that you want to get data from a folder?

Loading Data From Folder - (powerbi.tips)

Or try absolute path.

Best Regards

Community Support Team _ chenwu zhu

[amitchandak]

@Syndicate_Admin ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

refer old solution

https://community.powerbi.com/t5/Power-Query/Scheduled-Refresh-Dynamic-Data-Source-Microsoft-Lists/m...

https://community.powerbi.com/t5/Service/Scheduled-Refresh-using-Dynamic-Data-Source/m-p/2088745
Appreciate your Kudos.