Question

OData PowerBI connection to Creatio gives error every day

We have a PowerBI report connecting to Creatio through OData, with a data source refresh every day at 7am MST. Every single day, it fails with this message.

---------------------------------------------------------------------------------------------------------------

Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"OData: Request failed: The maximum number of redirections allowed was reached. (Found)"}}],"exceptionCulprit":1}}} Table: KwlBusinessLineCollection.

Then our Administrator goes into PowerBI and resubmits the refresh manually, and it works.

----------------------------------------------------------------------------------------------------------------

Has anyone encountered this or know the cause?

Thanks,

Like 0

Like

4 comments

Dear Heather, 

Please make sure that the flag LogSessionForSessionLessRequest is set to false in web.config in the root folder in installation files of your site. 

Dennis Hudson,

Is that something I have access to through the development console?

Heather,

 

If you have an on-site application you can find the web config file in the installation files. If you have a cloud application, you can request this information from the support team (support@creatio.com).

Heather,

 Did you manage to connect using Odata?

Show all comments