cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User II
Super User II

Data integration into CDS via Power Query

I am trying to understand the Data integration in CDS 2.  I have an Excel file which I saved on One Drive for Business and I have managed to create a Data Integration project for it to pull the data into CDS.  When data is updated in the Excel file it seems that I have to manually refresh the Data Integration to pull the new data in.  Is this correct or is there a way for it to automatically refresh?

 

I can't seem to find a lot of documentation on Data Integration for CDS 2 except for https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-cds-newentity-pq.... Does anyone know if there is more comprehensive documentation around?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Power Apps
Power Apps

Re: Data integration into CDS via Power Query

Correct - Currently you need to manually refresh your Data Integration projects to retrieve updated data for your entities. We're actively working on Scheduled Refresh capabilities and expect them to become available within the next couple of months.

 

The Data Integration capabilities in CDS 2 are based on Power Query. Power Query is a shared technology that enables Data Connectivity and Data Preparation in a wide range of Microsoft products, including Power BI, Excel, Analysis Services and CDS. Until we further expand documentation in the context of CDS, you can find more detailed documentation for Power Query in the context of these other products. These are a few pointers that will help you get started: https://docs.microsoft.com/en-us/power-bi/desktop-query-overview, https://support.office.com/en-us/a...

 

Please keep in mind that Power Query in CDS is still a subset of the capabilities exposed in other Desktop products. Particularly around breadth of supported data sources & data transformations, so some of the capabilities described in these tutorials might not yet work in the context of CDS.

 

Thanks,
M.

View solution in original post

4 REPLIES 4
Highlighted
Power Apps
Power Apps

Re: Data integration into CDS via Power Query

Adding @millopis from the Power Query team.

Thanks,
Clay.
Highlighted
Power Apps
Power Apps

Re: Data integration into CDS via Power Query

Correct - Currently you need to manually refresh your Data Integration projects to retrieve updated data for your entities. We're actively working on Scheduled Refresh capabilities and expect them to become available within the next couple of months.

 

The Data Integration capabilities in CDS 2 are based on Power Query. Power Query is a shared technology that enables Data Connectivity and Data Preparation in a wide range of Microsoft products, including Power BI, Excel, Analysis Services and CDS. Until we further expand documentation in the context of CDS, you can find more detailed documentation for Power Query in the context of these other products. These are a few pointers that will help you get started: https://docs.microsoft.com/en-us/power-bi/desktop-query-overview, https://support.office.com/en-us/a...

 

Please keep in mind that Power Query in CDS is still a subset of the capabilities exposed in other Desktop products. Particularly around breadth of supported data sources & data transformations, so some of the capabilities described in these tutorials might not yet work in the context of CDS.

 

Thanks,
M.

View solution in original post

Highlighted
Super User II
Super User II

Re: Data integration into CDS via Power Query

Thanks @millopis, that is very helpful.  Looking forward to the further enhancements

Highlighted
Helper II
Helper II

Re: Data integration into CDS via Power Query

Is the scheduled refresh from Excel into CDS feature working yet?

Whenever I try to set one up I get this error, which is not helping me at all.

RefreshImportError.PNG

 

@millopis @CWesener

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (6,787)