Forum Discussion
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 Script option):
import pickle
dataset['value'] = pickle.load(open(dataset['value'], 'rb'))
['value'] is the column that contains the pickles.
I got Error: TypeError: expected str, bytes or os.PathLike object, not Series.
I didn't find any way to resolve my problem.
Thank you!
4 Replies
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:
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.
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?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.
