Forum Discussion
'hubstorinfo' file problem
Community ChampionAnonymous As Parry mentioned, you can tell Power BI to ignore hidden files.
When you do Get Data > From File/Folder in Power BI, it should automatically generate the filter to remove hidden files.
What does the 'source' step look like for your broken query? Do you see a row for .hubstorinfo in the table?
Can you click the Advanced Editor tab of your table query that's broken and paste here please?
it has a filter line for hidden files...
- AllisonKennedy
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.
Screenshot after clicking on the 'Transform Sample File' query - thanks
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
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!
See below for sample file and another for when I click to see contents of the hidden hubs file