Forum Discussion
Use a datasource as test data to load and use a Python pickle file
Power BI noob here.
Our Python model is pickled and we want to use it from within Power BI to show results. The model saved as pickle (or even a json) would pick up data from a data source, run the model, append the predictions back to the data source, and then we would want to display the results in say a Multicard or Matrix. We need not do it on the fly but as an offline process to run and save the results, and then use the data to visulaize online.
Is this even possible?
3 Replies
skrubber , if you want to run the model outside and save the result file, then you can use the result file in power bi.
If not, then you have check if you can write that code while brining the data using python
check steps here to bring data
How to make Python work with Power BI: https://youtu.be/5D0BkNsu5CM
add your steps before you return dataset
Thanks for the link amitchandak -- will try this out and let you know if I can work with a pickle file inside the script
