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
anuradha01's avatar
anuradha01
Icon for Helper I rankHelper I
3 years ago

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.

 

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.