Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 screenshot is the exact error message I see. 

 

A few points:

- I can refresh this exact same table with fewer data, but when it's full data, it gives me the error.

- I'm using a sql native query for the table

 

Has anybody experienced this? What would be the cause for this?

 

 

Thanks in advance!

Need Help

11 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      It's between 12-17minutes. Pretty consistent

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        Is this dataset on a premium capacity?  If so, what SKU?  Maybe the table is too large for the SKU?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Is your table hitting the 10GB partition limit? Or maybe the capacity admin has specified a much smaller dataset limit?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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...? 

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        that is certainly possible. maybe you can change the timeout of the native query.