Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago
Solved

Live to DirectQuery for Power BI Datasets is broken?

Can anyone else confirm this behavior?   Hadn't tested this in a while but converting from Live to DirectQuery for Power BI Datasets and AS seems to be broken at least in the latest release of Po...
Need Help
  • JirkaZ's avatar
    JirkaZ
    3 years ago

    It's working for me as expected. Are you sure the dataset you're connected to is the "root" dataset and not another version of an existing dataset? There's a limit of the chain - I think it's 3 currently.
    Also few other things to check - do you have build permissions on the original dataset?
    Is XMLA endpoint enabled in the tentant and so is Analyze in Excel?

  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    JirkaZ You know what, I just realized what the issue is. I had datasets of the same name published in a Workspace as well as in My Workspace. Doesn't work for My Workspace datasets, only datasets in Workspaces other than My Workspace. Duh. I was accidentally connecting to the dataset in My Workspace.

JackP's avatar
JackP
Frequent Visitor
3 years ago

Greg_Deckler: Does this feature need to be enable for the entire organization, or it can be activated for dev team only?

Thanks

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

JackP That tenant setting can be enabled for specific security groups or to exclude specific security groups.

  • JackP's avatar
    JackP
    Frequent Visitor
    3 years ago

    Greg_DecklerWe did activate it for a specific security group for dev team.

    But for other users, would they be able to open reports using this feature (report and dataset published on premium capacity) ?

    Or all users need to be included in this setting?

     

    Thank you