Skip to main content
Microsoft Idea

Power BI

Needs Votes

Analyze in Excel data corrupted

Vote (6) Share
Larry Clark's profile image

Larry Clark on 09 Oct 2016 21:13:18

I pull a CSV file into PBI Desktop, create a report, publish it to PowerBI.com. Report looks good. Data model is working. Then I "analyze in Excel," and as I build a pivot table it's obvious that the database connection is corrupt. Zip codes mixed in with customer names, product codes mixed with fiscal year, etc...