Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
We have created a simple composite model containing a model from Azure Analysis Services as well as manually entered data.
Everything is working as expected in Power BI Desktop and DepartmentName from the Product table in AAS is displayed alongside Column1 from the manual table (named Table).
After publishing the report and dataset to the Power BI Service the visual fails when it includes any data from AAS. Data from the manual table can be displayed when it is the only source for a visual.
Clicking refresh on the dataset does perform a refresh. No error occur.
The reporting and dataset is published to a workspace under the new workspace experience and is under a premium capacity with read/write for the XMLA endpoint enabled.
The connection to AAS is OAuth2/Organizational and is in the context of a guest user on the tenant hosting the AAS service. This guest user is service admin on AAS.
Hi Anonymous - try publishing the dataset to a shared capacity workspace as a test. This might be a limitation of the AAS Client in Power BI Service. jeroenterheerdt any ideas ?
- jeroenterheerdt
I think the issue here is the "guest user" - there are limitations with working across tenants: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-services#tenant-considerations
