BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
You can import data into tabular models from virtually any data source, as shown by this tutorial.
- Importing data from other data sources
- Importing data from Excel, Access, CSV files or the clipboard
- Importing data from SSRS (Reporting Services)
- Importing from Analysis Services cubes/tabular models
- Importing from other data sources (this blog)
Posted by Andy Brown on 04 January 2016
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Importing from other data sources
You can also load data into SSAS tabular from the following other sources (not covered in this tutorial):
|Azure DataMarket||Link to data held in Microsoft's cloud-based services, by subscribing to a data feed of interest.|
|SQL Server Parallel Data Warehouse||When your database is seriously large you can accommodate it in a SQL Server PDW, and import data from there into your tabular model.|
|SharePoint||There is no specific data source for importing from SharePoint; instead, just choose one of the standard formats shown above, but provide a complete path to your report, workbook or PowerPivot model. If your data is in a SharePoint list, you can export this as a data feed and import this data feed into your model.|
|Data feeds||You can link to atom data feeds from the Internet and from other sources which support the Open Data Protocol (using files with extension .atomsvc).|
|Other databases||Link to Oracle, Teradata, Sybase, Informix and DB2 in a similar way to linking to SQL Server.|
|OLEDB / ODBC||Link to virtually any data source using these generic formats.|
One of the great strengths of the tabular model is that you can combine tables based on almost any data source, and treat them equally within your model (without needing to know where they came from).
And with those words of wisdom, I've reached the end of this particular blog.