PowerBI App not detecting Python as Data source

[roygau]

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 Desktp though.

I have an On-Prem Data Gateway (Personal Mode) running in a windows VM. The personal gateway is shown as online in the PBI service>Manage Gateway>on prem data gateways, after selecting personal mode from the drop down.

Also in the schedule refresh page the 'Gateway Connection', 'Data Source Credential', 'Schedule Refresh' options are not getting displayed for my report.

However while scheduling refresh, it shows an error as mentioned below:

"You can't schedule refresh for this dataset because the following data sources currently don't support refresh: Data source for Query1"

Upon clicking discover data sources, below message is displayed:

"Unable to determine the data source due to unknown functions. When custom connectors are used, the error can happen if gateway doesn't have the extension enabled. Details: Query contains unknown function name: Python.Execute."

In my PBI Desktop, the data source settings is displayed for Python with privacy as 'organizational'. While Global Permissions shows python as well as the oracle server to which I am connecting to with same privacy level.

Also in the Personal Gateway, the custom data connector has been disabled since I am using Python as data source.

Even with above configuration I am not able to schedule refresh. Kindly let me know where we are committing the mistakes.

Let us know if any other information is required.

FYR:

Personal Gateway Version: 3000.130.5.0

PBI Desktop Version: 2.104.941.0 64-bit (April 2022)

PBI Service version: 13.0.18620.44

Much appreciated,

Gautam.

[v-kkf-msft]

Hi @roygau ,

It may be because you are using python packages that are not supported by Power BI Service.

Learn which Python packages are supported - Power BI | Microsoft Docs 

Best Regards,
Winniz

[roygau]

I am trying to install packages as supported by PowerBI App. Currently facing issue to install packages due to VC++ error, let me resolve this issue and get back if the package versions indeed resolves the main issue in hand or not.

[roygau]

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]

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

[roygau]

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]

Facing the same issue, Have you resolved it ?

[roygau]

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

[lbendlin]

What is your rationale for not using the native Oracle connector?