Forum Discussion

Arnar's avatar
Arnar
Regular Visitor
8 years ago

Analysis Services- Import vs Connect live error.

Power BI is working fine on my tabular model, in desktop and import data. However, if I choose to connect live to import same Model/data, I get error; “Couldn’t load the data for this visual” and th...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Arnar,

 

Did your Windows user have enough permission in the SSAS server? Because only Windows credential can be used in the live connection. Please refer to desktop-analysis-services-tabular-data#frequently-asked-questions.

>>>Yes. Your current Windows credentials are used to connect to the Analysis Services server. You cannot use Basic or stored credentials in either the Power BI service or Power BI Desktop when exploring live.

 

Best Regards,

Dale

Arnar's avatar
Arnar
Regular Visitor
8 years ago

Hi@Dale

 

Think I have found the error, in a PowerBi site it is written „Limitations of Analysis Services live connections “is Server version 2016 and standard SKU or higher, another site says that DirectQuery from SSAS is an Enterprise only feature.

 

I am using SSAS server 2017 Standard Edition version 14.0.1000.169

 

It would be fine if someone could confirm my notion of this findings

 

Regards

Arnar