Forum Discussion
Power Query & M for Populating Any Database
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).
Oh, I see.
Well, I wish "Get Data" could be a generic, cloud-based service...
- With all the same (and ever-increasing) options for data sources;
- And the same easy-to-use query interface, but also full power of M for more advanced users;
- And a variety of options for data targets -- the list of which might also be ever-increasing, but obvious ones would include:
- Analysis Services tabular (Azure and on-premises)
- SQL Server databases (Azure and on-premises)
- Other databases like MySQL, PostgreSQL, etc. (cloud and on-premises)
- Flat files like Excel and CSV
From what I've seen in my (cursory) research, Microsoft would have a(nother) market-leading ETL product to offer. Right?
Or, what else are you all using that you might recommend as a comparable alternative?
I would be interested to see what the community can share around this. I can see where a DB agnostic ETL tool would be very powerful to users, but also possibly detrimental to the DB providers as this would make their tech less sticky.