This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice. This article is not considered official documentation for K2 software and is provided "as is" with no warranties.
When using Power BI with K2 Analytics template to generate reports, you may notice that when generating SmartObjects against Power BI, this operation fails with warnings stating "failed to generate".
This is done against the Odata API SmartObjects, which needs to be enabled within K2 Management. If you try to perform refresh within Power BI, you are still presented with the same error.
Everything on the OData API SmartObjects section of K2 Management page appears to be fine, and the SmartObject report executes without issue. However, if you run a Fiddler trace while trying to load the Power BI report you will get the following error in Fiddler:
400 Bad Request
To resolve this issue perform the following steps:
Navigate to K2 Management >Integration >API's > SmartObject OData, uncheck "Record Limit" and then click on Apply Changes.
This issue has been been resolved in K2 Cloud update 7 and K2 5.3.