Forum Discussion

tahechadv_2022's avatar
tahechadv_2022
Icon for Helper II rankHelper II
3 years ago
Solved

Convert M Language to Python

Hi guys!   The code below is from Bitrix24 it connects automatically to our database and download the tables directly in PBI, but PBI service can not automatically update the dashboard.   I would...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI tahechadv_2022,

AFAIK, current it only supports R and python scripts as the data source and they will also require a personal data gateway to handle and execute these scripts.

For the sample M query, I'd like to suggest you add the get token steps before the current steps, then these codes can be refreshed without manually updating tokens.

Regards,

Xiaoxin Sheng

  • tahechadv_2022's avatar
    tahechadv_2022
    Icon for Helper II rankHelper II
    3 years ago

    I think didn't explain it clearly.

     

    I do not want to write any script inside PBI.

     

    I want to write this code in python, to execute it in our server in order to download the tables to our DW instead of downloading it to PBI.