Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Analyze in Excel: Data could not be retrieved from database.

I have several users that are no longer able to use the Analyze in Excel feature. Build permissions have been granted and global build permissions are turned on for the app. Through testing, the only...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi, Jay.

 

Thank you for your response.

 

Those who are having problems already have build permissions on the dataset and users are allowed to connect to the app's underlying dataset within the app.

 

Oddly enough, a user who is getting the error message screenshot in my original post, is able to work with a file connected to the dataset when I send it to him. Any thoughts?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi rami_el,

 

Did you figure out what causing problem?

We have simmilar error when user trying to refresh report to SSAS server.

The situation is odd because error will not appear if on begining filter will be used.

 

I think this is correlated with last MS Office update - we are checking this scenario right now.

(On old 2016 Office without last updates all worked fine)

 

Please let me know where you are with this problem.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I still haven't found a solution.

     

    Let me know if you come accross one.