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

Hi, all,

I have one report using data imported from databases. And another team developed a report which gets data from hundreads of excel files, I need the same data and don't want to bother myself to import the data again, so I tried to connect their PBI dataset instead. Which created a "composite model" and I failed with this solution due to the following 2 problems encountered:

(1) I couldn't set refresh schedule for my dataset due to the credential setting error:

 Seems that this is a known issue, but when can it be fixed? (https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-services#considerations-and-limitations )

(2) When I shared the report to other users, they couldn't see the visuals with data from the direct query dataset.

I have figured out the root cause: When we share report to another user, a "link" will be created and added into the backend dataset. But with composite mode, the link is only added to the "local" dataset, not to the direct query dataset. 

I tired "Live connet" mode and found that PBI can add the link to the source dataset when the report is shared.

So I guess here PBI has a bug. Could you please help to fix it?

By the way, seems that PBI currently doesn't support live connect to multiple datasets, is it possible to add this feature? It will be helpful to consolidate reports (just put them together, no data exchange between datasets which we know direct query is needed).