Connect to PowerBI Table

Like (0) Share

Report

Posted on 5 Dec 2022 16:45:05 by wshalex123

160

Hello,

i got a calculated (custom) table in PowerBI.

I would like insert it in my app, so i need a connection via Dataverse (Dataflow). I can't find anything on the web... Which connector is the right one? Or am i on the completly wrong path? Any other suggestion?

Can someone help me out?

Categories:

Tables

Dataflows

Microsoft Dataverse

I have the same question (0)

All responses (2)

Answers (0)

wshalex123 160 on 06 Dec 2022 at 09:09:34

Like (0)

Report

Re: Connect to PowerBI Table

Hey @AJ_Z ,

thanks for your response.

I made a connection to my SQL Server in Dataverse and created a Dataflow for two tables (The tables whom i need for the 1 calculated table). The next logical step would be to combine them in a oData query (Like in a calculated table in PowerBI). But what URL do i have to put in the OData connector??

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on 06 Dec 2022 at 00:15:32

Like (0)

Report

Re: Connect to PowerBI Table

From my experience it has not been possible to pull things from Power BI Datasets into Dataverse or connect to them in apps. The approach I have always needed to take was to connect to the sources of the Power Bi Tables Data, either directly or by manipulating them in power query with a dataflow.

Was this reply helpful? Yes No