Forum Discussion

tessahurr's avatar
tessahurr
Icon for Microsoft Employee rankMicrosoft 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
dennistoting162's avatar
dennistoting162
New Member
5 years ago

Thre is an error when adding other data source error: DirectQuery to AS An error occurred while loading the model. Verify that the connection information is correct and that you have permissions to access the data source.

 

MBonnett's avatar
MBonnett
Icon for Advocate II rankAdvocate II
5 years ago

dennistoting162 you will want to verify if you have XMLA endpoints and Analyze in Excel with on-premises datasets enabled in the admin portal (this is required). We also had this error and found this was the root cause of the through a Microsoft Support Ticket.