Forum Discussion

HadasSpier's avatar
HadasSpier
Helper 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
v-robertq-msft's avatar
v-robertq-msft
Community Support
5 years ago

Hi, HadasSpier 

According to your error message, I think the error happens because you are passing Series and the error message says you can't do that. And the error occurs in your Python code. You can refer to these links for help:

https://stackoverflow.com/questions/61575159/typeerror-expected-str-bytes-or-os-pathlike-object-not-tuple-with-os-path-bas

https://stackoverflow.com/questions/51098103/how-to-fix-this-errror-builtins-typeerror-expected-str-bytes-or-os-pathlike-ob

https://stackoverflow.com/questions/51615227/failed-to-upload-file-with-the-typeerror-expected-str-bytes-or-os-pathlike-ob

https://stackoverflow.com/questions/60962474/typeerror-expected-str-bytes-or-os-pathlike-object-not-geojsonfile

 

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
    Helper 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
      Community 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
        Helper I
        5 years ago

        It will not work in my case, unfortunately,

        thanks for the help anyway!