I am using a native SQL Server connection with Excel PowerPivot and in some cases it throws an error related to aliases (below). The issue is that the query does have aliases and will run fine if run
right on the box.
This is only an intermittent problem, most times it reads the query fine.
Here is the query that most recently gave me trouble:
from FactPurchase f
left outer join DimEvent e on f.eventid = e.eventid
where e.eventid is null
Error is: The SQL statement is not valid because it contains the following duplicate column names: EventID. Correct the statement by prodiving aliases for the columns.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.