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

Hi tessahurr!
You asked for stacked datasets, I tried 😉
Let's do not think about if this makes any sense for real purpose...

I did build up 3 seperate datasets and then joinded them with an imprted table:
1) works fine
2) Access permissions to each single dataset no problem
3) DAX query is fine
4) Of course you have some how to handle duplicated dimension tables... (Geo)

Then I made of this complete model a dataset again.

This shoud be the base of a user report.

But I got some access issue... "Single Sign-on"?

Multiple Datasets

Single datasset build of multiple datasets