Moving Power Query from Excel to SSAS RRS feed

  • Question

  • We are using Excel 2013 Power Query and PowerPivot to build data models that will be moved to SSAS Tabular. Are there any gotchas that will not import? I have seen in testing that we have to be careful about importing files. Excel likes drive letters and SQL Server prefers the UNC path. We aren't likely to have many/any files in the production state, but I'm wondering if there are other gotchas like this, especially with Power Query.
    Tuesday, September 23, 2014 3:17 PM


  • Hi Mike. While you should be able to transfer the PowerPivot model into an SSAS model in VS, you won't be able to refresh the data once it's there. Power Query isn't currently supported in Visual Studio or SSAS.


    Thursday, October 16, 2014 7:36 PM

All replies