Convert M Language to Python

[tahechadv_2022]

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 like to convert it to Python (or any other programming language) in order to upload the tables in our DW. Then it would be easier to connect PBI desktop to our DW and automatically update the dashboards

response = Web.Contents(
"https://" & #"Server address",
[
RelativePath = "bitrix/tools/biconnector/pbi.php",
Query = [
//token = #"Secret key",
table = bx24_entity_name
],
Content = Json.FromValue([dateRange = [
startDate = Date.AddYears(Date.From(DateTime.LocalNow()),-1),
endDate = Date.From(DateTime.LocalNow())],
key = #"Secret key"
]
)
]
),
jd = Json.Document(response)

[tahechadv_2022 · Accepted solution]

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.

[v-shex-msft]

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 · Accepted solution]

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.

[tahechadv_2022 · Accepted solution]

https://BITRIX-SERVER/bitrix/tools/biconnector/pbi.php?token=SECRET-KEY&table=TABLE_NAME

just relace bitrix-server, secret-key and table name, using a GET method and you'll be able to download the tables.