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...
Is your table hitting the 10GB partition limit? Or maybe the capacity admin has specified a much smaller dataset limit?
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