Forum Discussion

coco6l's avatar
coco6l
Frequent Visitor
2 years ago

Power BI Service OData Connection Issue with SAML2 Authentication

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 connectio...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

please show a sanitized version of your Power Query code.

coco6l's avatar
coco6l
Frequent Visitor
2 years ago

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 ?