Forum Discussion

Oluduroj's avatar
Oluduroj
New Member
9 years ago

Power BI Ecel Add-ins

I am currently connecting to a Power BI data source in excel. I keep getting this error when I click on a field, I was wondering if anyone has encountered the same. This error pops up with Excel 2016...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Oluduroj,

 

Based on the error message, it seems that it's a limitation for DirectQuery models. In your scenario, do you use SSAS data source in directQuery model? Please try to use import model and check if this issue persists or not. And provide us more details, so that we can reproduce this issue and make further analysis.

 

Regards,

Charlie Liao

Oluduroj's avatar
Oluduroj
New Member
9 years ago

Hi Charlie,

Thanks for your response. You are right this is a DirectQuery but using a SQL server database as my data source. I haven't tried using the import model. I'll try that today and i'll let you kbnow if I get the same error. Thanks.

 

 

Best Regards,

 

Olu.