question

JaseDaggett-5897 avatar image
0 Votes"
JaseDaggett-5897 asked Ehren answered

PowerBI Composite Model: Can you reference the DirectQuery portion in M?

I enabled "DirectQuery for PBI datasets and AS" in the options menu, so that I could make a composite model with an existing PBI Dataset and mixing it with some local excel files.

However, I'm looking to make custom queries in M based off of the data in the DirectQuery. Is this possible? I do not see the DirectQuery data anywhere in M. Do I need to use a specific call in order to retrieve it? Or is it not possible?

power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Ehren avatar image
0 Votes"
Ehren answered

It sounds like the PBI Dataset access is happening in your report model, not in Power Query. If that's the case, you likely won't be able to directly access the Dataset from M.

However, you might want to ask about this over on the Power BI Community site.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.