Forum Discussion
automate routine functions with VBA-like script
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