-1

Recently, i have started on one requirement where i need to migrate reports from other technologies to PowerBi so as part of report migration i am using power bi rest api (https://learn.microsoft.com/en-us/rest/api/power-bi/push-datasets) which supports to create datasets in PUSH mode. using which i am able to call Power Bi Rest API to create datasets and add data into datasets using JSON format.

but problem is actual report's data are available in millions of rows. stored in some database tables. so, we can not provide in JSON as a static data.

Our requirement is we need to create Power Bi semantic layer through Rest API (or any other programmatic approach) which can be connected with some dataSource like MySQL Database tables.

or just let me know if i need to use any other approach to achieve this functionality !!

Thanks !!

i have tried using power bi rest api with push semantic model but that will not be valid for long term

Improve this question

1 Answer 1

Reset to default
0

Power BI semantic models in DirectQuery mode only support SQL-based sources. You can't do DirectQuery to a web API.

In DirectQuery mode the semantic model needs a data source that can understand and efficiently process SQL JOIN, GROUP BY and WHERE clause queries. Web APIs can't do that.

If you just want to write a report against a web API, you can use the Power Query "Get Data" experience in Power BI Report Builder and build a Paginated Report.

Connect paginated reports to data sources using Power Query in Power BI Report Builder

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.