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

it has a filter line for hidden files... 

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

Anonymous  Thanks for the screenshot - looks like the error might be happening even earlier than we thought. Can you please select the 'Transform Sample File' query that has the error symbol next to it and see what's happening there? You might see a 'Go to Error' button. If you do, please click it, then take a screenshot and also select the previous step and take another screenshot. Post both here if you still haven't solved by then. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Screenshot after clicking on the 'Transform Sample File' query - thanks

     

  • 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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    See below for sample file and another for when I click to see contents of the hidden hubs file