cancel
Showing results for 
Search instead for 
Did you mean: 

DirectQuery for Power BI dataset feature doesn't work when connecting via the XMLA endpoint

The DirectQuery for Power BI datasets and AAS preview feature doesn't work if you connect to a Power BI dataset via the XMLA endpoint using the Analysis Services connector.

The connection works fine, but the model stays in "Live" mode with no option to "Make changes to this model" in order to combine it with other DirectQuery and imported data.

If you connect to a Power BI dataset using the Power BI datasets connector, this feature works fine. If you connect to an AAS dataset using the Analysis Services connector, the feature also works fine. I can't see anything in the docs that would suggest this not working.

 

Why can't I just use the Power BI dataset connector?

I'm trying to test the scenario of connecting to a Power BI dataset in Power BI Desktop using a B2B Guest user account. Because Power BI Desktop doesn't allow you to sign in to a tenant other than your home tenant, I can't use the Power BI datasets connector. So I thought I'd try connecting to the XMLA endpoint using the Analysis Services connector. Which, as mentioned, allows me to successfully connect to the model, but the "DirectQuery for Power BI dataset" feature doesn't work.

 

Anyway...

The account I'm using to log in with here is irrelevant - the "DirectQuery for Power BI datasets and AAS" feature doesn't even work when connecting with an account in the correct tenant (in fact, the screenshots below are using an account in the correct tenant).

I would have thought connecting to a Power BI dataset through the XMLA endpoint explicitly is pretty much equivalent to using the Power BI dataset connector (or even the AAS connector, for that matter).

 

Steps to reproduce:

  1. Retrieve the XMLA endpoint connection string for the workspace + dataset (powerbi://...)
  2. Use the Analysis Services connector to connect to the Power BI dataset
  3. See the lack of option to make changes to the model

edfreeman_0-1633705897916.pngedfreeman_1-1633705907926.pngedfreeman_2-1633705942994.png

edfreeman_4-1633706230507.png

edfreeman_5-1633706316860.png

 

cc:// @jeroenterheerdt 

 

Status: New
Comments
jeroenterheerdt
Microsoft

Thanks, this is actually by design. The B2B portion of your question is something we're working through now to see if we need to change our thinking.

ed-freeman
Helper II

Hey @jeroenterheerdt, thanks for the speedy response.

That's interesting. Am I allowed to ask why? As you'll be aware, there's the multi-tenant AAS example for a B2B user in the docs - I'd have thought what I'm trying to achieve here is equivalent to this, just with a Power BI dataset as the source instad of AAS. Would be happy discussing our use-case separately in more depth.

In the meantime, would it be worth adding a limitation to the docs along these lines?

Thanks, Ed

v-chuncz-msft
Community Support

@ed-freeman 

 

You may share feedback via Ideas to help improve Power BI.