Share via

Visio Visual with VBA inside Power BI Desktop/Service

Anonymous
2023-07-13T01:59:22+00:00

Hello,

I am currently working on a project that involves importing visual from Visio inside Power BI report. I created a diagram in Visio and plan to highlight connected shapes and connectors whenever I click on one of the boxes. I found out that the way I can do that is by using VBA inside Visio. However, I wanted to confirm if I can import a Visio visual inside Power BI with VBA implemented in it. Will the code still work when it is inside the Power BI? I wanted to confirm about this first before I buy Visio plan, and I could not found a direct answer anywhere.

Thank you in advance!

Microsoft 365 and Office | Visio | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2023-07-13T04:34:08+00:00

    Hello Hana K

    I’m Adeyemi and I’d be happy to help you with your question. In this forum, we are Microsoft consumers just like yourself.

    Power BI does not directly support importing Visio diagrams with VBA code embedded in them. When you import a Visio diagram into Power BI, it becomes a static image and loses the interactive features and functionality associated with VBA.

    Power BI is primarily designed for data visualization and analysis, and while it can display static images, it does not have built-in support for running VBA code or interacting with Visio diagrams in the same way as the standalone Visio application.

    If you require interactive functionality or dynamic highlighting of connected shapes and connectors based on user interactions, you may need to consider alternative approaches. One option is to export your Visio diagram as a static image and use it as a background image in Power BI. You can then use Power BI's native visualizations and interactivity features to achieve some level of highlighting and interactivity.

    Alternatively, you could explore using other custom visualizations or JavaScript-based libraries within Power BI that offer advanced diagramming and interactive capabilities. These may require additional development efforts compared to using VBA within Visio, but they can provide more flexibility in terms of integrating interactive diagrams into your Power BI reports.

    I hope this helps.

    Kind regards, Adeyemi

    2 people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest