We have a Vue based application which is using Embed for your customers config for embedding content / reports in our application.
Currently we are doing all steps manually for example
- Creating Azure app
- Security Groups
- Workspace
- Workspace Settings (Capacity etc)
- Access permissions
- Report creation (Save as template (PBIT)) using PowerBI Desktop app
- Dataset creation / transform (Clickhouse / Postgres using ODBC)
- Add Data Gateway (Refresh schedule / on demand / api)
- Publish
We want to automate all the steps ideally but the most important part is Report / Dataset Creation / Publish for each new onboarding.
Each customer / client has it's own data and security so each one will have it's own workspace sharing of data is not possible in any case.
Microsoft Docs - https://learn.microsoft.com/en-us/rest/api/power-bi/reports
Currently when referring to powerbi docs we found out that we don't have any option to automatically create report and dateset which will be clickhouse and postgres odbc
Till now I have found that we can clone the report but not create the new one as shown below -
https://learn.microsoft.com/en-us/rest/api/power-bi/reports/clone-report
We have to automatically create / embed report whenever any customer signup on our app.
Note - We are using Clickhouse Odbc and Postgres Odbc as our data connectors for all of our reports.
If we can get any reference document for all the above steps automated or atleast for report / dataset creations that would be very helpful.
