Forum Discussion

Brutus97's avatar
Brutus97
Frequent Visitor
3 years ago

Dataverse Virtual tables have no option for Direct query???

I want to make a Power BI report that use virtual tables from Dataverse and it should be working with Direct Query.   With normal dataverse tables I get the question: Do you want an import or direc...
Need Help
v-yadongf-msft's avatar
v-yadongf-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Brutus97 ,

 

Virtual tables allow Microsoft Dataverse to surface data stored outside of the Dataverse relational storage for use in Power Platform. Data accessed through a virtual table looks and acts like a native Dataverse table. For example, your SQL Server data can be accessed through Dataverse tables, using Dataverse APIs and plugins and can have relationships to your native Dataverse tables like accounts, contacts, or other custom tables you create.

 

Virtual tables can be used to connect to tabular data (SQL, Excel, SharePoint), non-tabular data (data lake, Azure Cosmos DB, SAP), data accessed through direct OData calls, or custom connections that users can craft to meet their needs.

 

For more information, please refer to: Microsoft Dataverse - Virtual tables | Microsoft Learn

 

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Brutus97's avatar
Brutus97
Frequent Visitor
3 years ago

Hello Yadong,

 

Thank you for your reply. It gives information about what virtual tables can and do, maybe my knowledge isn't sufficient, but is it possible to do direct query y/n in POwer BI on virtual tables. I don't see/understand the answer in your reply.

 

Thank you in advance!