Power BI - Importing fbprophet and using Anaconda as Default Python

Hi Guys,

The other day, I was trying to use the fbprophet package to do a Time Series Analysis using Python  through Power BI and "Smack!", I hit a roadblock. I tried installing the fbprophet packeage using

pip install fbprophet

but it threw a ton of errors. So naturally I looked around on the internet and came across quite a number of forums that confirmed there was a problem when installing fbprophet through pip on Windows 10.

One such link is

https://github.com/facebook/prophet/issues/2

While I was reading through a few more articles I found out that by using the Anaconda platform it was possible to install and implement the fbprophet package and so I tried it out and after a few struggles I managed to get it to work!

These are the steps I took,

1. Uninstalled the existing python instance/s on my machine

2. Deleted the existing application folders

3. Downloaded the graphical installer(Python version 3.7) for Anaconda from the website below

https://www.anaconda.com/distribution/

4. Executed the download package and did the following

  • Select 'just me'




  • Keep the default destination folder as it is

  • Enabled both the Advanced Option (Add Anaconda3 to my PATH environment variable and Register Anaconda3 as my default Python 3.7)

5. Install

6. Once installed, open the Anaconda3 Navigator and launch the CMD.exe Prompt (it will open up a command propt where you can install packages, list information .etc.)







7. The fbprophet package has a prerequisite which is the pystan package and therefore it needs to be installed first. To install it run the following command

conda install pystan
    

  • Please note that there maybe instances you need to install Microsoft Visual C++ 14.0. Follow the link below to install Visual Studio Build Tools
    •
8. Next install the fbrpophet package

conda install -c conda-forge fbporphet

9. Open up PowerBI and click on Transform Data

10. Go to File > Options and Settings > Options and select the Python Scripting Tab and select the python directory where you installed the Anaconda3 (It is usually Detected and available in the dropdown list. Also you might see 2 with the same name. You can select either)

Now you can run your python script on Power BI and import and use the fbprophet package as well.

Here is a sample code written along with an output on Power BI





Hope this comes in handy
Cheers!











































Comments









  1. UnknownAugust 18, 2020 at 5:06 PM
    Hey Nilhan, I am trying to run a prophet model on Power BI but I keep getting an error when I'm trying to start the Python script. Any suggestions when dealing with scripting errors on Power BI?
    I am using Anaconda on my local computer and the error asks me to install the mkl-service package which I have tried doing, but it does not help. Let me know how you went about running your Python script, thanks!
    ReplyDelete
  2. Lafay Tech PlazaApril 13, 2021 at 1:43 AM
    Microsoft Power BI is aData Analytics tool for business users, who want to analyze data quickly, easily, and accurately. Power BI is part of the Microsoft BI suite, and is one of the most user-friendly tools for data analytics in the market today. One of the main challenges when you are using a data analytics tool is finding the best data sources to analyze. In this article, I am going to show you two data sources that you can use with Power BI: first, the fbprophet Python library, which creates long-term forecasts, and second, Anaconda, which is a distribution of Python.
    ReplyDelete
  3. James ZicrovJune 26, 2021 at 5:00 AM
    Thank you so much for providing such a unique and descriptive analysis of Power BI and REST API.

    Powerbi Read Rest

    ReplyDelete











Post a Comment























Popular posts from this blog









Integrating data onto Power BI from INSIGHTLY CRM




















Image







Hi Guys,  The other day I was looking at possibilities to get data from INSIGHTLY and visualize it through Power BI.  I was given the following link that lead me to the INSIGHTLY Developer portal,    https://api.insightly.com/v3.1/Help#!/Overview/Technical_Details     and I came across the following article that showed how to directly connect the REST API to Power BI,     https://dev.applicationinsights.io/documentation/Using-the-API/Power-BI     I followed the steps mentioned on the page associated with the link above and voila! it worked! However, the above article talks about "Displaying a time series using the Metrics API".     Let ma explain how this can be applied to get data from INSIGHTLY.   For this example, lets look at the steps required to get Project related data onto Power BI.     Pre-requisites     1. Access to INSIGHTLY. You can sign up for a Free 14 Day Trial.   2. Power BI Desktop.     Steps     1. Login to INSIGHTLY CRM > Navigate to the user menu and se








Read more










Power BI- Route Map




















Image







Hey Guys, It’s been awhile :p   So, I was working on a little project where I wanted to show a proper route that was mapped correctly (much similar to google maps) on Power BI, however there was no visual supporting it at the time. As always, I looked into alternatives for this and I found a visual called route maps on the market place by Weiwei Cui.                      Figure 1 : Route Map - PBI Marketplace                   I was also able to find the guide for this visual (link below)      https://weiweicui.github.io/PowerBI-Routemap/      This did not quite do the trick as it showed the displacement of the two inserted locations and not the route to it.                   Figure 2 : Incorrect Route (Displacement)                     I was getting a little annoyed this point, so I googled alternate options and I found out these things.    The ability to create customs points on google maps  The ability to export it in KML/KMZ Format  The ability to convert it to an Excel file       








Read more