Tag: SQL Server 2014

For SQL Server 2014 – Use the following link below to use an oData Source to get data from SharePoint List into your table

Below are the steps if you want to use SQL Server 2014 to get data from a SharePoint list into your database. The URL below explains how to download and install the OData Source for SQL Server 1.       Click on the following link below a.       http://www.microsoft.com/en-us/download/details.aspx?id=42295 2.       Then once you load the page click on Download a.       This will then…

Error: An Item with the same key has been already added – Unable to load the tables in the Power Pivot Window

NOTE: First thing to do is to make a copy of your Excel Workbook, before making any changes to your Power Query Source. If you do NOT, and change your Power Query source, your Power Pivot Model could become unusable! 1.      I had an issue where if I changed the Power Query source from a CSV after I made changes…