Forum Discussion
Cannot refresh a table in SSMS through xmla endpoint
I'm trying to refresh a table in Power BI dataset through XMLA endpoint in SSMS. I'm getting this error. "Stream does not support reading. The remote server returned an error: (400) Bad Request." The...
The thing is I'm able to refresh the data in Power BI desktop. The table itself only contains 10 million rows with 10 columns. But the native query is somewhat complex and long. Maybe it's the query generating big materializations at intermidiate steps that go over a certain limit...?
that is certainly possible. maybe you can change the timeout of the native query.
Yeah I have set it at 3 hrs and runs fine in PBI desktop. It's sad ssms doesn't give a useful message in my case
Which refresh type did you specify in the XMLA? and did you target an individual partition?
I've tried both. They give me the same error though 😅