locked
Error Loading Metadata RRS feed

  • General discussion

  • Following steps in Mr. Excel book PowerPivot for the data analyst. Imported data fine. Created a relationship between 2 tables fine. Added 2 columns (Year / Month) using DAX fine. Then, try to create a pivot table. Select revenue column (which should put data into values portion of pivottable). I get an error on my screen: "Error loading cube metadata: A data source must be specified in the connection string." I click through this error and the data does seem to find its way into the pivot table. Can anyone tell me why I am getting this error message? I am using 32 bit office 2010. I have SQL Server 2008, but not R2. Windows 7 Enterprise.
    Sunday, July 4, 2010 4:12 PM

All replies