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?
Is this still an issue?
Ed Price, Power BI & SQL Server Customer Program Manager (Blog,
Answer an interesting question?
Create a wiki article about it!
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?