Power Query the Excel Data Model?

Status
Not open for further replies.
E

efglover

New Member
Joined
Dec 14, 2010
Messages
3
I have imported data into the Excel Data Model and I need to transform it. I don't see the data model as a source for Power Query. How can I query the data model?
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Sort by date Sort by votes
Duplicate to: Power Query connection to PowerBI dataset?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.
 
Upvote 0
Status
Not open for further replies.

Similar threads

B
  • Question
How to use the lookup capability in Power Query
Replies
1
Views
118
Matt Allington
M
M
  • Question
Power Pivot data model import into Power BI desktop issue
Replies
2
Views
477
mancich
M
J
  • Solved
Issue with Power Pivot measures & slicers
Replies
4
Views
81
Jaunkalns
J
T
  • Question
Aggregation tables do not include real-time data
Replies
0
Views
118
TamirBasin
T
RICH937
  • Solved
Power Query: Averaging values when greater than zero
Replies
7
Views
285
RICH937
RICH937

Forum statistics

Threads
1,215,206
Messages
6,123,639
Members
449,111
Latest member
ghennedy

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top