Error while adding new OData Dataflow

[vojtechsima]

Hi,

I am trying to add a new Dataflow, using the OData source. I used the same source several times without issues, however, now I got this error:

Unknown error from external service: DMTS_InvalidEncryptionAlgorithmError (Session ID: 965dc84c-7906-45f2-87ff-0c61176d1c74)

My credentials are correct (I can add it without any issue in Power BI Desktop), I used this source several times without issues, just a different URL from the same source.

[vojtechsima · Accepted solution]

@Anonymous , @Watsky 

Hi guys,
I couldn'T resolve it, however, I found a workaround, it's a little bit more work but it works as it should.
Create new DataFlow using Blank Query, copy Power Query code from Advanced Editor (from Power BI Desktop), enter desired credentials (doesn't need any encryption like that) and save it.

However, it's strange nonetheless, because in the new workspace when I pasted the same link, it gave me "Use Encrypted Connection" option but in my old Workspace, I didn't get this option. It obviously then worked with the Encryption mode and it entered the credentials on its own, somehow it inherited it from somewhere I have no clue, to be honest.

[Anonymous]

Hi @vojtechsima ,

According to the error message,DMTS_InvalidEncryptionAlgorithmError

I think you need to encrypt your credentials when you load - not made very clear in the documentation. You can't just upload the free text.

Makes sense for security! Refer to :https://docs.microsoft.com/en-us/power-bi/developer/encrypt-credentials

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

[vojtechsima]

@Anonymous 
Hi,
how I can encrypt it when I just simply put the text into box, I used this several times without any issues:

Sorry for the Czech language, but this is how I add the new the Dataflow and it's how I always do it without any issues.

[Watsky]

Hey @vojtechsima ,

Does the URL use HTTPS? If the URL was using HTTP try it with HTTPS. 

Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

[vojtechsima]

Hey @Watsky ,
unfortunately, I am using Https already. Do you have any other tip how to fix this random issue please?

This is the link:
https://servicedesk.homecredit.net/rest/aio-bi/1.0/powerbi/export/NTYwZWRjNzYtYWY3Yi00ODc3LTllNzUtNT...