Forum Discussion

kevhav's avatar
kevhav
Continued Contributor
9 years ago

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 experi...
General Comment
dkay84_PowerBI's avatar
dkay84_PowerBI
Microsoft Employee
9 years ago

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).

kevhav's avatar
kevhav
Continued Contributor
9 years ago

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?

  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    Microsoft Employee
    9 years ago

    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.