Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

'hubstorinfo' file problem

I load my excel files from a folder as they are similar. This has worked through several refreshes but now P-Bi won't refresh - initially looked like it was 64 or 32 bit problem - but I have 32 bit n...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Code from advanced editor for the sample file. FNDWRR Sheet is the common named sheet in the excel files where I pull the data from (get data - file - folder).

 

let

Source = Excel.Workbook(Parameter1, null, true),
FNDWRR_Sheet = Source{[Item="FNDWRR",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(FNDWRR_Sheet, [PromoteAllScalars=true])
in
#"Promoted Headers"

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous Ok, that code looks fine provided that each sheet is always named "FNDWRR"

 

What is the current value for the 'sample file' if you click that query now please? Sorry for all the questions!