Forum Discussion

roygau's avatar
roygau
New Member
4 years ago

PowerBI App not detecting Python as Data source

Hi,   I have a dashboard which is build using Python as a data source. I am though connecting to Orale DB using python library Oracle-Client. Not facing any issue to connect to the db from PBI Desk...
Need Help
roygau's avatar
roygau
New Member
4 years ago

We can use but there are huge issues...We have to do a lot of data manupulations on the raw data followed by lots of complex calculations to build each and every visual which is next to impossible to do it with Power query, hence we chose python to do it. Python gives us maintainibility on the data which can later be used for expanding the dashboard apart from other advantages.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Validate that the machine where your personal gateway is running on has all required packages installed.

  • roygau's avatar
    roygau
    New Member
    4 years ago

    In my local machine, I am using Python 3.8.2 while in the VM where Personal Gateway is present has python 3.8.0. also other python packages (numpy, pandas, cx-oracle & matplotlib) are slightly different versions in both the m/c

    Does the all versions (python & packages) need to be same?

    How to ensure Personal Gateway is picking the right versions intalled?, is there any config ? 

    Also I have disabled Custom data connector in Personal gateway, do we need to enable that when we are using Python as data source.

    • mukil_raj's avatar
      mukil_raj
      New Member
      4 years ago

      Facing the same issue, Have you resolved it ?

       

      • roygau's avatar
        roygau
        New Member
        4 years ago

        Currently installing compatible package versions in gateway environment. Will let you know if that resolved the issue.