Forum Discussion

anuradha01's avatar
anuradha01
Icon for Helper I rankHelper I
3 years ago

Combining Excel files on multiple sharepoint folders using Power BI

Hi All   I have Excel sheets saved on multiple different sharepoint folders. They all have the same format but different data. I need to combine data from all the Excel sheets and generate some Po...
Need Help
danextian's avatar
danextian
Icon for Super User rankSuper User
3 years ago

Hi anuradha01 ,

 

Tested it myself and a custom function refreshed just fine  in the service so there could be other factors at play.

 

anuradha01's avatar
anuradha01
Icon for Helper I rankHelper I
3 years ago

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.