Node js 应用程序与 power bi Rest Api 集成

使用Node.js应用程序与Power BI REST API集成

javascript
const request = require('request');
const client_id = 'your_client_id';
const client_secret = 'your_client_secret';
const redirect_uri = 'http://localhost:3000/callback';
// Step 1: 获取授权码
const authUrl = `https://login.microsoftonline.com/common/oauth2/authorize?client_id=${client_id}&response_type=code&redirect_uri=${redirect_uri}`;
console.log(`请在浏览器中打开以下链接并登录授权：\n${authUrl}`);
// Step 2: 获取访问令牌
const code = 'your_authorization_code';
const tokenUrl = 'https://login.microsoftonline.com/common/oauth2/token';
const options = {
    method: 'POST',
    url: tokenUrl,
    headers: {
        'Content-Type': 'application/x-www-form-urlencoded'
    },
    form: {
        grant_type: 'authorization_code',
        code: code,
        client_id: client_id,
        client_secret: client_secret,
        redirect_uri: redirect_uri
    }
};
request(options, (error, response, body) => {
    if (!error && response.statusCode == 200) {
        const access_token = JSON.parse(body).access_token;
        console.log(`访问令牌：${access_token}`);
    } else {
        console.error('获取访问令牌失败。');
    }
});

javascript
const request = require('request');
const access_token = 'your_access_token';
const workspace_id = 'your_workspace_id';
const dataset_id = 'your_dataset_id';
// Step 1: 导入数据
const importUrl = `https://api.powerbi.com/v1.0/myorg/groups/${workspace_id}/datasets/${dataset_id}/imports`;
const importOptions = {
    method: 'POST',
    url: importUrl,
    headers: {
        'Authorization': `Bearer ${access_token}`,
        'Content-Type': 'application/json'
    },
    body: JSON.stringify({
        name: 'Sample Data',
        fileUrl: 'https://example.com/sample-data.csv'
    })
};
request(importOptions, (error, response, body) => {
    if (!error && response.statusCode == 202) {
        const import_id = JSON.parse(body).id;
        console.log(`数据导入中，导入ID：${import_id}`);
    } else {
        console.error('数据导入失败。');
    }
});
// Step 2: 创建报表
const reportsUrl = `https://api.powerbi.com/v1.0/myorg/groups/${workspace_id}/reports`;
const reportOptions = {
    method: 'POST',
    url: reportsUrl,
    headers: {
        'Authorization': `Bearer ${access_token}`,
        'Content-Type': 'application/json'
    },
    body: JSON.stringify({
        name: 'Sample Report',
        datasetId: dataset_id
    })
};
request(reportOptions, (error, response, body) => {
    if (!error && response.statusCode == 201) {
        const report_id = JSON.parse(body).id;
        console.log(`报表创建成功，报表ID：${report_id}`);
    } else {
        console.error('报表创建失败。');
    }
});