Forum Discussion

LeboeufHarry's avatar
LeboeufHarry
Helper I
4 years ago

Troubles Runnen Python sqlparser

Hello, I'm trying to 'extract' the sql tables/views used in some sql statements. In Python this is quite easy with sqlparser. So I thought using this in PowerBI/Query. This is my code (Temporary o...
Need Help
v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi LeboeufHarry ,

 

Did you try to use SQL Server connector's advanced options to execute SQL statements, like this:

 

 

Best Regards,
Winniz

  • LeboeufHarry's avatar
    LeboeufHarry
    Helper I
    4 years ago

    This has nothing to do with executing SQL command, its about parsing the commands found in the SQL Auditing files.

    This is Python, but the saving with Pandas to csv files is internal PowerBI Engine stuff, we have no control on this.