Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hi @FelipeGualberto,
I would suggest you create an idea here.
Best Regards,
Dale
Hi @FelipeGualberto,
I would suggest you create an idea here.
Best Regards,
Dale
Thanks for the confirmation, I'll create.
For those interested in this idea, please vote in: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13535403-create-a-report-dashboar...
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
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.
Maybe it has a good reason so no one can easily read the source code 🙂
#Copyright
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
1 | |
1 | |
1 | |
1 |