Hi,
I was trying to import some FactTables and DimTables from Excel recently. When I try import them I can see some of them Tables with suffix xlnm#_FilterDatabase are appearing in my Table list.
This is not the first time it's happening and very annoying. Sometimes I had imported these xlnm#_FilterDatabase Tables and got some incorrect results in the PowerPivot tables.
I never used any type of filters in my data.
Where are these coming from?
Where is the fault?
How to deal with them?
I need a standard way of avoiding them with out appearing in my Table List.
One more question about the source data I have been haunted by.
Can I have formulas in my source Excel tables which are meant for importing into PowerPivot engine??
Thanks in advance
Skeptical
I was trying to import some FactTables and DimTables from Excel recently. When I try import them I can see some of them Tables with suffix xlnm#_FilterDatabase are appearing in my Table list.
This is not the first time it's happening and very annoying. Sometimes I had imported these xlnm#_FilterDatabase Tables and got some incorrect results in the PowerPivot tables.
I never used any type of filters in my data.
Where are these coming from?
Where is the fault?
How to deal with them?
I need a standard way of avoiding them with out appearing in my Table List.
One more question about the source data I have been haunted by.
Can I have formulas in my source Excel tables which are meant for importing into PowerPivot engine??
Thanks in advance
Skeptical
Last edited: