# Power BI API Scraper: decoding a published report query format

> Power BI API Scraper reconstructs the web client's undocumented query and response format for published reports. It sends SemanticQueryDataShapeCommand requests, follows restart tokens and expands bitsets and ValueDicts into CSV rows. The included example is hardcoded for an Ohio liquor permit report.

- Type: Case study
- Targets: Protocol · Website
- Category: Independent reconstruction cases
- Relationship: Independent reconstruction project
- Sources reviewed: 2026-11-06
- Added to the catalog: 2026-11-06
- Original resource: <https://github.com/artemiyDev/powerbi_api_scraper>
- Primary source: <https://github.com/artemiyDev/powerbi_api_scraper/blob/053ffeaec40a2c85a1086c3bb9b36c5d4d19ea87/README.md>
- Catalog page: <https://awesomerea.org/resources/power-bi-report-query-case/>
- Record JSON: <https://awesomerea.org/resources/power-bi-report-query-case/record.json>
- Chinese version: [简体中文](https://awesomerea.org/zh/resources/power-bi-report-query-case/index.md)

## Requirements & limits

- **Prerequisites:** Python 3.7+ and requests; access to a public Power BI report.
- **Scope:** The included query, resource key and model ID are hardcoded for one report; retargeting requires code changes.
- **Limits:** Non-200 responses stop the run, and overlapping pages are not deduplicated.
- **License:** MIT License.

## Primary sources

1. <https://github.com/artemiyDev/powerbi_api_scraper/blob/053ffeaec40a2c85a1086c3bb9b36c5d4d19ea87/README.md>

## More in Websites

- [webcrack](https://awesomerea.org/resources/webcrack/index.md) · Tool
- [humanify](https://awesomerea.org/resources/humanify/index.md) · Tool
- [WABT](https://awesomerea.org/resources/wabt/index.md) · Tool
- [wasm-tools](https://awesomerea.org/resources/wasm-tools/index.md) · Tool
- [Chrome DevTools MCP](https://awesomerea.org/resources/chrome-devtools-mcp/index.md) · Integration
- [mitmproxy](https://awesomerea.org/resources/mitmproxy/index.md) · Tool

## About this entry

The description was reviewed against primary sources.
Original editorial content: MIT. Linked projects, papers and assets retain their own rights and licenses.