Connecting to Virtual Tables in PowerBI

How can I connect?

When I wanted to connect to the virtual table, my first instinct was to use the Dataverse connector since they are virtual tables, on Dataverse. Opening up PowerBI, connecting to Dataverse, there were no virtual tables visible.

Of course, the work around would be to connect to the source directly, but I did want to see if I could make it work.

This connector is available for:

  • Power BI (Datasets)
  • Power BI (Dataflows)
  • Dynamics 365 Customer Insights

You cannot use the Dataverse connector, it wont display the tables.

When you use the CDS Data connector, you do see the tables. Take note, they will have a prefix, and then table name. Depending in method of importing, it will either be prefix_dbo_name or prefix_name.

Virtual Table through CDS Connector

Power Query Common Data Service (Legacy) connector - Power Query | Microsoft Learn

Check out this Microsoft article on more indepth explanation on it: