topic Re: Create Power BI Reports programatically in Developer

Create Power BI Reports programatically

FelipeGualberto — Thu, 31 May 2018 21:48:44 GMT

Is it possible to create queries, relationships, measures and visuals programatically in PBI Desktop through code, and/or modify/create a PBIX file?
I'm trying to parametrize the creation process of PBIX files.

Re: Create Power BI Reports programatically

az2451 — Fri, 01 Jun 2018 12:35:05 GMT

You can not even print reports in Power BI, so what do you expect?

Just kidding 🙂 but it is planned for the next updates

Back to the topic: I tried to modify the PBIX by unpacking it and reading the code. But you can't decently work with this anymore.

For e.g. if i convert a custom visual into a PBIX file (the project folder involves typescript, json, less code etc.) the code will change completely.

Every variable/function has a letter now and all comments are gone, it is just bad to work with and hard to understand the code.

So after creating a PBIX package is not possible the retrieve the source code in good shape or make it undone because the process of the packaging simplifies the code which is not irreversibel.

This means: you can not modify the PBIX but you can create one by using Power BI CLI. I would suggest to take a look in custom visuals. It is actually possible in there to create queries, relationships, measures and visuals.

Here is a great tutorial for the beginning: https://tsmatz.wordpress.com/2016/09/27/power-bi-custom-visuals-programming/

Greetings,

Berat

Re: Create Power BI Reports programatically

FelipeGualberto — Fri, 01 Jun 2018 12:33:38 GMT

I simply unpacked the PBIX file, changed the timestamp of a file by saving, packed it again and the PBIX didn't open anymore.

That is developer proof.

Re: Create Power BI Reports programatically

az2451 — Fri, 01 Jun 2018 12:41:33 GMT

Maybe it has a good reason so no one can easily read the source code 🙂

#Copyright

Re: Create Power BI Reports programatically

v-jiascu-msft — Mon, 04 Jun 2018 05:33:27 GMT

Hi @FelipeGualberto,

I would suggest you create an idea here.

Best Regards,

Dale

Re: Create Power BI Reports programatically

FelipeGualberto — Wed, 06 Jun 2018 12:09:47 GMT

Thanks for the confirmation, I'll create.

Re: Create Power BI Reports programatically

FelipeGualberto — Mon, 11 Jun 2018 14:44:37 GMT

For those interested in this idea, please vote in: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13535403-create-a-report-dashboard-programatically-using-th