PDA

View Full Version : Data Model as a Data Source



mhumpher
2016-03-29, 06:09 PM
I have two workbooks with different processes, but using some of the same data. I'm using power query to pull in the data and I'm trying to figure out if there is a way to connect to the data model or power queries from a second workbook. I don't want to use two queries, one in each workbook, because I want to ensure the data is the same. Is there any way of doing this?

Ken Puls
2016-03-31, 04:54 PM
If the workbook is published to Sharepoint I believe you can. Alternately, you can publish the workbook to PowerBI.com (for free). That essentially turns your workbook into an Analysis Services server that you can connect to from Excel.