Power BI Service OData Connection Issue with SAML2 Authentication

[coco6l]

Hello Power BI Community,

I'm experiencing an issue with an OData connection to SAP in Power BI Service that I'm hoping someone could help me with.

In Power BI Desktop, I've configured my connection successfully, and everything works fine. However, when I attempt to configure my connection on Power BI Service, I encounter a problem where the connection is unexpectedly closed.

The request I'm using is structured as follows:
`https://XXXXXXX/ZC_DEBOURS_HEURES_CDS/ZC_DEBOURS_HEURES(p_days=165)/Set/?saml2=disabled`

It appears that Power BI Service is ignoring the `saml2=disabled` parameter. This is leading to a failure in the data source credentials update process, with the error message indicating that the underlying connection was closed. The specific error message I'm receiving is: "OData: Request failed: The underlying connection was closed: The connection was closed unexpectedly."

Has anyone encountered a similar issue, or does anyone have more information on a potential workaround or solution to this problem? Any insights or guidance would be greatly appreciated.

Thank you for your assistance!

Best regards,

Coco

[Anonymous]

Hi @coco6l ,

I think the reason why this parameter is ignored by the service has to do with the type of parameter you create when you create the parameter on the desktop, because according to the limitations described in the official documentation, "any" or "binary" type parameters are valid in Power BI Desktop, but we don't support them in the service at the moment!

Edit parameter settings in the Power BI service - Power BI | Microsoft Learn

You can try to change the parameter type, then re-upload it to the service and see if you can configure the credentials.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

please show a sanitized version of your Power Query code.

[coco6l]

Hi @lbendin thank you for your answer,
Here is my sanitized power query code :

let
    Source = OData.Feed("https:/XXXXXXXXXXXXX/sap/opu/odata/sap/ZC_DEBOURS_HEURES_CDS/ZC_DEBOURS_HEURES(p_days=165)/Set/?saml2=disabled", null, [Implementation="2.0"]),
    #"Type modifié" = Table.TransformColumnTypes(Source,{{"WorkDate", type datetime}, {"Compteur", Int64.Type}, {"Matricule", Int64.Type}, {"p_days", Int64.Type}, {"Quantite", Int64.Type}, {"Heures", type number}}),
    #"Type modifié1" = Table.TransformColumnTypes(#"Type modifié",{{"WorkDate", type date}})
in
    #"Type modifié1"

I don't use any parameter nor type any or binary.
Do I need to create all parameters ?

[lbendlin]

Your URL looks ... interesting ...  You may want to follow the guidance here and naviagate off the base URL instead.

Power Query OData Feed connector - Power Query | Microsoft Learn

Personally I would use the provided attributes, especially the Query attribute