cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Javier_Gonz
Frequent Visitor

Dataverse table join query

Hi Teams

 

I need create a new table in my environment. This table has columns from some another tables. I´m trying create the new table from a data flow using power platform flow as data source.  I get to connect but it doesn't show data. What it's wrong? I want transform data with power query and then provision the new table

1 ACCEPTED SOLUTION

Accepted Solutions
EricRegnier
Super User II
Super User II

Hi @Javier_Gonz,

I get the same behavior, actually I was never able to use Power Platform dataflow as a data source. The way I import from another Dataverse environment is using the out-of-the-box OData connector. URL is your WEB API url (i.e. https://<org name>.api.crm6.dynamics.com/api/data/v9.1/) and sign in with the Organisation Account option. Check out this post for the images: https://powerusers.microsoft.com/t5/Microsoft-Dataverse/CDS-to-CDS-Data-Integration/m-p/586311 

 

Hope this helps!

View solution in original post

2 REPLIES 2
EricRegnier
Super User II
Super User II

Hi @Javier_Gonz,

I get the same behavior, actually I was never able to use Power Platform dataflow as a data source. The way I import from another Dataverse environment is using the out-of-the-box OData connector. URL is your WEB API url (i.e. https://<org name>.api.crm6.dynamics.com/api/data/v9.1/) and sign in with the Organisation Account option. Check out this post for the images: https://powerusers.microsoft.com/t5/Microsoft-Dataverse/CDS-to-CDS-Data-Integration/m-p/586311 

 

Hope this helps!

View solution in original post

Thank you very much @EricRegnier , your answers have been very useful

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (68,869)