Forum Discussion

charleshale's avatar
charleshale
Continued Contributor
1 year ago
Solved

How to run python in power query

I have a python file in pycharm that takes a csv of CIKs (the EDGAR ticker symbol identifier) and scrapes the number of subsidiaries.    This is the script in case you want to know....but my issue i...
Need Help
  • TomMartens's avatar
    TomMartens
    1 year ago

    Hey charleshale , 

    if the BeautifulSoup package is not supported by the PowerBI Service, then there is a problem.

    Maybe it's possible to create a Python App running in Azure or an Python function. Let's create this App or Function do the data extraction create JSON document, a csv, or a Parquet file then will be consumed by Power BI.

    Hopefully, this provides an idea of how to tackle your challenge.

     

    Regards,

    Tom

TomMartens's avatar
TomMartens
Super User
1 year ago

Hey charleshale , 

if the BeautifulSoup package is not supported by the PowerBI Service, then there is a problem.

Maybe it's possible to create a Python App running in Azure or an Python function. Let's create this App or Function do the data extraction create JSON document, a csv, or a Parquet file then will be consumed by Power BI.

Hopefully, this provides an idea of how to tackle your challenge.

 

Regards,

Tom