Power BI connector changelog!

[gokermu (Mucahit Bilal GOKER)]

Hey @community!

We’re buzzing with excitement to share some HUGE updates with you all! We just shipped Power BI Connector 3.0.0 and honestly, we’re pretty proud of this one. It’s absolutely packed with features and fixes you’ve been asking for.

New Features

Coloring is BACK!

Coloring functionality is back and better than ever! We’ve addressed the major issues from previous versions and restored full coloring capabilities to help you visualize your data exactly how you need it.

Hide Speckle Branding (Business Plan)

By popular demand, Business plan users can now hide the Speckle logo from their visuals, giving you complete control over your dashboard’s branding and appearance. Learn more about Business Plan.

cc @M_Ra

Full Screen Mode

Hide the top bar and sidebar buttons for a clean visual.

Conditional Formatting is Back!

One of the most missed features from our legacy connector is back! Conditional formatting is now fully restored, allowing you to create dynamic, data-driven visualizations.

cc @asif

Ghost Mode

You can now toggle between completely hiding filtered elements or showing them in a subtle ghosted view. It’s perfect when you want to keep context but highlight specific stuff. We couldn’t resist the ghost puns – sorry not sorry!

cc @Mohamed_Elmasri

Perspective vs Isometric Toggle

You can now switch between perspective and isometric projections with a single click.

Update Notifications

Never miss an update again! When a new version is available, you’ll see a convenient Update button right in the visual interface, ensuring you always have access to the latest features and improvements.

Critical Fixes

Loading Issues Resolved

We’ve solved the frustrating “loading forever” problem that some users experienced. This issue occurred when:

• Incorrect fields were connected (e.g., connecting Object IDs to Version Object ID inputs)
• Deleting and re-adding visuals on saved files where model data was not loaded previously

The connector now displays helpful banners when data expectations aren’t met, making troubleshooting much easier.

Model Federation Improvements

We’ve squashed several bugs related to model federation, ensuring smoother operation across complex data scenarios.

Tooltip Data Display

Fixed an issue where tooltips weren’t showing linked data. Tooltips now properly display all relevant information. Thanks @hakan52 for reporting it.

What’s Coming Next

Advanced Coloring Controls

We’re not stopping here with coloring! Our next focus is enabling color customization and sorting controls, giving you even more flexibility in how you present your data.

Power Query Helper Functions

We’re developing helper functions for Power Query to streamline data workflows and make it even easier to work with your Speckle data directly in Power BI.

We Want to Hear From You!

Your feedback drives our development priorities. Here’s how you can get involved:

• Feature Requests: Have an idea for a new feature? Create a thread in our Feature Requests category
• Bug Reports: Experiencing issues? Post in our Help category with details

🏃‍➡️ Get Started Today

Download and install Power BI connector today.

[gokermu (Mucahit Bilal GOKER)]

What’s New Since 3.0.0 >> 3.1.2

Hey @Community ,

It’s been a while since our last announcement, but we’ve been busy cooking up some exciting improvements to your Speckle Power BI experience! Here’s what’s been added since our last major release:

Auto Property Extraction

Now properties are automatically extracted and cleaned up without any extra configuration. This is currently only available for applications that support DataObjects.

• Supported applications: Revit, Archicad, Navisworks, Tekla, ETABS, Civil.
• Not supported applications: Rhino, SketchUp, AutoCAD.

Control Camera Animation on change

We’ve added a new setting to control the camera animation on change. Now, you have control if you want camera to stay still when it’s being filtered by other visuals.

Persistent Settings and Filters

Your preferences matter! Now settings you applied are persisted across sessions. So you don’t have to keep setting them every time you open your report. Colors and filters are now persisted as well per visual instance. So if you filtered a model or applied a color to a model, it will be the same when you open your report again.

Helper Functions

We’ve added a series of functions to Speckle namespace to help you work with the data you’re pulling from Speckle.

Speckle.Objects.Properties

Properties can be a pain to work with: They can be nested and be in different formats. We’ve added a new helper function to help you work with properties.

Speckle.Objects.Properties(inputRecord as record, optional filterKeys as list)

This function will return a record with the properties and their values that are in the input record. You can also filter the keys that are returned. So instead of getting a record with all the properties, you can get a record with only the properties you want.

Speckle.Objects.CompositeStructure

We’ve added a new helper function to help you work with the composite structure of an object. So you can quickly get the composite structure of a Wall, Floor, Roof or any element type that has a composite structure.

Currently this is only available for Revit and Archicad.

Speckle.Objects.CompositeStructure(inputRecord as record, optional outputAsList as nullable logical)

Accepts the object record as input and returns a record with the composite structure of the object by default. There is an optional parameter to return the composite structure as a list. This option is useful for expanding the each element into its own row if you want to.

Speckle.Objects.MaterialQuantities

We’ve added a new helper function to help you work with the material quantities of an object. So you can quickly get access to material quantities. It is intended to be used in “Add Column” flow, so it interacts with individual records.

Speckle.Objects.MaterialQuantities(inputRecord as record, optional outputAsList as logical)

Accepts the object record as input and returns a record with the material quantities of the object by default. There is an optional parameter to return the material quantities as a list. This option is useful for expanding the each material quantity into its own row if you want to.

Speckle.Models.Federate

You could already federate models if you were to give a federated model url as input to the data connector. But now we’ve added a new helper function to manually federate loaded individual models.

This helper function is useful if you already have the models loaded in your Power BI report and you want to federate them.

Tip: You can federate models from different projects using this helper function.

Speckle.Models.Federate(tables as list, optional excludeData as logical)

Accepts a list of tables as input (you can federate multiple models at once) and returns a table. There is an optional parameter to exclude the data from the federated models. This option is useful if you only want to use the fields for 3D Visual (Version Object ID and Object IDs).

Speckle.Utils.ExpandRecord

We’ve added a new helper function to help you expand a record fields. This is especially useful when used in combination with Properties helper function.

It expands record fields into their own columns.

Speckle.Utils.ExpandRecord(table as table, columnName as text, optional FieldNames as list, optional UseCombinedNames as logical)

Accepts a table as input, column name that contains the record you want to expand and adds new columns for each field in the record. There is an optional parameter to filter the fields that are expanded. And an optional parameter to use combined names for the new columns.

Coming Soon

We are going to release a series of tutorials to help you get the most out of the new features. Keep an eye out for them on our YouTube channel!

We are also planning to release Power BI templates to help you get started with the Power BI connector.

Love these new features? Found a bug? Have ideas for what’s next? We’d love to hear from you!

[Ignacio_Diaz]

It’s a huge step forward! So glad to hear my work flow will be so much smoother! Thanks for you all!

[gokermu (Mucahit Bilal GOKER)]

3.2.1 is out!

Hey @Community ,
New release for Power BI connector is out! This release addresses two quality of life improvements:

Fixed ghosted object selection behavior

Previously, objects set to display as ghosted or hidden were still selectable, causing unexpected behavior. With this release, ghosted objects are now properly non-interactive and cannot be accidentally selected. This improves the overall user experience when working with filtered object sets.

• Note: Upcoming release will address the related issue where double-clicking on non-selected elements still triggers focus behavior.*

OAuth2 support for data gateway

Power BI’s data gateway enables connections to data sources behind firewalls or in private networks, commonly used in enterprise environments. Previously, Data Gateway users required Personal Access Tokens for Speckle authentication. OAuth2 authentication is now supported, allowing users to authenticate with their Speckle account credentials. This streamlines the authentication process and eliminates the need for manual token management.

Get Started Today

Download and install Power BI connector today.