Issue loading Power BI Application

  • 15 February 2022
  • 0 replies
  • 12 views

Userlevel 5
Badge +20
 

Issue loading Power BI Application

kbt162406

PRODUCT
K2 Five 5.1
BASED ON
K2 Five 5.1
TAGS
Power BI
End User
Administrator
Troubleshooting Document
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.
LEGACY/ARCHIVED CONTENT
This article has been archived, and/or refers to legacy products, components or features. The content in this article is offered "as is" and will no longer be updated. Archived content is provided for reference purposes only. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.

Issue

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.

 

 

Symptoms

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

Troubleshooting Steps

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.

 Image

This issue has been been resolved in K2 Cloud update 7 and K2 5.3.


0 replies

Be the first to reply!

Reply