Forum Discussion

HadasSpier's avatar
HadasSpier
Icon for Helper I rankHelper I
5 years ago

Unpickle from column with python

Hi everyone, I connected my Power BI report to my SQL DB. I have in my DB a column that contains Pickle files. I need to unpickle that column in Power BI. I tried to do so with python (Run Python S...
Need Help
HadasSpier's avatar
HadasSpier
Icon for Helper I rankHelper I
5 years ago

Thanks for your reply.
Yes, I understood the error, but I need to Unpickle the column, and I didn't find any other way to do so.
Do you have any other ideas?

v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, HadasSpier 

According to your description, if you want to unpickle the column in the Power BI, I think you can try to use the “Extract” function in the Power query.

 

You can follow this document to check if it can help you to achieve your requirement:

https://www.sqlshack.com/extract-column-information-using-the-extract-function-in-power-bi/

 

Best Regards,

Community Support Team _Robert Qin

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

  • HadasSpier's avatar
    HadasSpier
    Icon for Helper I rankHelper I
    5 years ago

    It will not work in my case, unfortunately,

    thanks for the help anyway!