Forum Discussion
Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Hi Team,
Scenario : I am trying to connect (live/import) to a Azure Analysis Service dataset on (Tenant A) from Power Bi desktop (on Tenant B).
I am to
* successfully connected (live/import) to the AAS dataset (on Tenant A) using PBI desktop (Tenant B).
* Successfully published the PBIX file with the AAS dataset (Tenant A) to PBI service (on Tenant B)
But not able to run the report or load the file on the PBI service (Tenant B)
For a Live connection to AAS dataset
* It throws the error "Cannot load model
Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again."
Eventhough the connection to the AAS dataset (on Tenant A) runs file without error. I am able to refresh the dataset but this doesn't get loaded to the report
For an import mode :
I get the attached gateway error. I have installed the personal gateway and Changed the account running the Gateway from the default service account to a domain user. Seems like the gateway service account (Tenant B) is not able to impersonate the Tentant A login credentials.
Is there a limitaion in using DirectQuery to AAS dataset between two different tenants ?
Any help is highly appreciated