更多内容关注博客：焦棚子
Python 获取 DAX 和 powerquery-m 官方文档信息, 用于代码分析和快速查阅等。
# 版本：Python 3.9.13pip install -r requirements.txtpython main.py
# dax 文件, 大约耗时 276.18 秒！
# m 文件, 大约耗时 386.98 秒！键名如下：
url-en-us: 函数英文版链接url-zh-cn:函数中文版链接description-en-us:函数英文版简短说明category-en-us:函数英文版分类url-category-en-us:函数英文版分类链接category-zh-cn:函数中文版分类url-category-zh-cn:函数中文版分类链接description-zh-cn:函数中文版简短说明url-dax-guide:函数英文版 SQLBI 链接
{
"CALCULATE": {
"url-en-us": "https://learn.microsoft.com/en-us/dax/calculate-function-dax",
"url-zh-cn": "https://learn.microsoft.com/zh-cn/dax/calculate-function-dax",
"description-en-us": "Evaluates an expression in a modified filter context.",
"category-en-us": "Filter functions",
"url-category-en-us": "https://learn.microsoft.com/en-us/dax/filter-functions-dax",
"category-zh-cn": "筛选器函数",
"url-category-zh-cn": "https://learn.microsoft.com/en-us/dax/filter-functions-dax",
"description-zh-cn": "在已修改的筛选器上下文中计算表达式。",
"url-dax-guide": "https://dax.guide/calculate/"
}
}键名如下：
url-en-us: 函数英文版链接url-zh-cn:函数中文版链接description-en-us:函数英文版简短说明category-en-us:函数英文版分类url-category-en-us:函数英文版分类链接category-zh-cn:函数中文版分类url-category-zh-cn:函数中文版分类链接description-zh-cn:函数中文版简短说明
{
"Excel.Workbook": {
"url-en-us": "https://learn.microsoft.com/en-us/powerquery-m/excel-workbook",
"url-zh-cn": "https://learn.microsoft.com/zh-cn/powerquery-m/excel-workbook",
"description-en-us": "Returns the contents of the Excel workbook.",
"category-en-us": "Accessing data functions",
"url-category-en-us": "https://learn.microsoft.com/en-us/powerquery-m/accessing-data-functions",
"category-zh-cn": "数据访问函数",
"url-category-zh-cn": "https://learn.microsoft.com/en-us/powerquery-m/accessing-data-functions",
"description-zh-cn": "返回 Excel 工作簿的内容。"
}
}
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent