Hi
From Marco Russo's
blog I see I can import a complete table using DAX:-
Evaluate 'Table Name'
When I run the import, Powerpivot prefixes each column with the table name, i.e. "Table NameColumn1", "Table NameColumn2", etc..; is it possible to avoid this?
Also, what would be ideal is if I could import my entire model using DAX or similar into Powerpivot. Is this possible without having to specify each table individually?
Thanks
Blair