Data Model as a Data Source

mhumpher

New member
Joined
Mar 29, 2016
Messages
2
Reaction score
0
Points
0
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

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,517
Reaction score
4
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
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.
 
Top