Forum Discussion
Power Query & M for Populating Any Database
I have been looking for an easy-to-use, cost-effective ETL tools to populate a typical, relational, star schema data warehouse.
Recently, I think I read that the Get Data / Power Query / M experience is now available for creating an Analysis Services tabular model. (Right?)
That got me thinking: "I wish I could use the Get Data / Power Query / M toolset, to populate any target database." Such as an on-premise SQL Server database. Or, say, any relational database on Amazon RDS, like PostgreSQL or MySQL or Aurora. Or, Amazon Redshift.
There is no way to do this currently, right?
If not, why? Wouldn't it be awesome?!
In the meantime, any recommendations for alternatives? Thanks!
6 Replies
In SQL Server vNext (still in private preview), MSFT has begun to implement the familiar Get Data experience, but the number of data sources (aka connectors) is currently limited. But yes, this is an easy way to populate a tabular model without using SSIS.
dkay84_PowerBI, interesting, thanks!
If it's going to be part of SQL Server, then I wonder, does that mean SQL Server will be the only possible target? Or, like SSIS, will there be many options for possible targets?
SSAS is where the Get Data experience resides (from SSDT where you can choose to build a 1400 level tabular model for SSAS). Therefore, SSAS is the only landing spot for the data. I don't believe there is any effort to have support for other DBs (including SQL).
