Forum Discussion

malleshG's avatar
malleshG
Frequent Visitor
4 years ago
Solved

DataSource.Error: AnalysisServices: The remote server returned an error: (400) Bad Request.

HI Team,   I have connected to power bi dataset with analysis service mode in power bi desktop(import mode) and the report was working fine earlier and refresh happing without error. where from few...
critical
Issue
refresh failure
  • lbendlin's avatar
    lbendlin
    4 years ago

    400 usually means a malformed DAX query. But in your case it sounds more like expired credentials. 

malleshG's avatar
malleshG
Frequent Visitor
4 years ago

Yes, I am using dax query. earlier it was working fine, now am getting the error while validating my credentials, mean now i am not able to connect any power BI data set in anlysis service mode

lbendlin's avatar
lbendlin
Super User
4 years ago

400 usually means a malformed DAX query. But in your case it sounds more like expired credentials. 

  • malleshG's avatar
    malleshG
    Frequent Visitor
    4 years ago

    Power BI admin was disabled the analyze in excel option, now its enabled and i am able to connect and refresh the data set