Forum Discussion

tessahurr's avatar
tessahurr
Microsoft Employee
5 years ago

Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)

Hit Reply and let us know what you think of the DirectQuery for Power BI datasets and Azure Analysis Services.  To learn more about this feature, please visit this blog post or our documentation.   ...
General Comment
jeroenterheerdt's avatar
jeroenterheerdt
Microsoft Employee
5 years ago

you need build permissions on the full chain at the moment.

jpierzchala's avatar
jpierzchala
Advocate I
5 years ago

I'm not entirely sure what do you mean by that. 

My experience is that if you have a build permission to a dataset you can build reports on top of this dataset (using live connection mode) and publish to service even if you're not a member of the workspace, the dataset resides in.

However, the moment you change to DirectQuery mode (the "make changes to this model" option) publishing no longer works due to the exception above

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I added dataset as datasource to an existing file with other datasources as well. now I see the dataset in the Fields pane on the right and in the Model view, but when I hit Transform data the dataset does not appear in the Power Query editor...

     

    For exampke I wanr to merge existing data source with data from dataset - how can it be done?

     

    thanks