Forum Discussion
automate routine functions with VBA-like script
Scott_Visio how much data is too much data, it is a big debatable question. Power BI has an amazing compression algorithm but it all depends on what is included in the data, cardinality, and also type of data (numeric vs string), and above all how good is data model, and how efficient are DAX code, all these leads to performance, scalable solution.
Having said that, size is not the only thing that can have a performance impact and many more things to consider. I worked with 300 ~ 400 million rows dataset and these perform lightning-fast, at the same time I have seen models (poorly designed), with small data sizes and perform very badly, so there is a lot to consider.
All the best on your journey and the community is there to support you in this journey.
Cheers!!
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Interesting point about high performance with hundreds of millions of rows but circumstances where the model has a negative effect. I'll look for some design tips and revisit my model.
Back to my original question about VBA-like automation functions using a specific example: a report has ten pages, one for each floor of a building, and each page includes a floor plan created with Visio and the Visio Visual. Each page also includes a collection of slicers and other visuals. I'd like to make the same change, perhaps a formatting change, to each visual of a certain type on each page. Describing this in VBA-like pseudocode:
for each page
for each visual
if visual.name = "ABC" then
<make changes>
end
next visual
next page
Possible to script this for Power BI? From what I've heard so far, I'm guessing the answer is no, but thought I'd ask.
Hi, Scott_Visio
This feature is currently difficult to implement in PowerBI reports.It is indeed a good proposal. I think you can post it on the PowerBI Idea forum. If you get enough votes, the Product Team will evaluate and consider it.
Best Regards,
Community Support Team _ Eason
