Forum Discussion
Combining Excel files on multiple sharepoint folders using Power BI
Would it not be easier to copy all of the Workbooks to a single folder, and import from there? Is it more practical to add such pain to this?
I can do it for my Excel files. Once its all in one SharePoint folder then how will I combine it?
Also with 25 Google sheets, there are Google forms set up by the team owners and it might not be feasible for them to do that. So would still need a solution to that.
Hi anuradha01 ,
Tested it myself and a custom function refreshed just fine in the service so there could be other factors at play.
Hi danextian
I removed all other steps from my report . Kept just the data load from List of files stored in parameter table. It still gives same error-
Below is the parameter table file that stores all files URL
This file path is stored in parameter - p_parameter_tbl
Below is the function code
All the files are read one by one from parameter table and then function is invoked to load data in Event_Register_Parameter_Tbl
However its still showing the error when I am trying to set refresh schedule.
