Use a datasource as test data to load and use a Python pickle file

[skrubber]

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?   

[skrubber]

Thanks for the link @amitchandak -- will try this out and let you know if I can work with a pickle file inside the script  

[Anonymous]

Did this work. If it did, please could you let us know how?

[amitchandak]

@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