Forum Discussion
Need Cookie in my Rest API Custom data connector - Help please.
Did any of you get through the cookies process? I'm having a hard time working with cookies in power query. There is no information online about it and no doc that can be referred to, making it even more difficult. I see one more post where it was mentioned that the cookies were not allowed due to security reasons in past:
https://community.powerbi.com/t5/Developer/How-to-get-set-Cookies-inside-a-visual/m-p/347843
Hello Team
I'm still chasing for the information on cookies. I would appreciate any response.
how can i solve this? I also find myself in the same situation.
PQ does work with cookies. All you have to do is create a custom connector with VS.
Check this article from microsoft and follow their TripPin walkthrough.
rlemmi This is a good news. Its been a long time since I spent time building an OAuth connector and cookies didn't work back then. Maybe I'll go through that link some time. Thanks
Anonymous From what I've understood, Power Query doesn't work with cookies and I stopped chasing it. However, I did hear a couple of them getting through the cookies process using powershell or python inside the power query code. You may want dig more onto this option(currently this is the only option as far as I know).
Thank you for responding, I was reviewing the ability to do it with python, however this script would have to run in 'Power Query Web' because that is where I am creating the 'dataset', however I could not does not exist in the data source options.
. That is why I am trying to solve it only with M Language.I really don't know what else to do to get the data from that API safely.
