Unanswered

Use data from Common Data Service database in excel

(0) Share

Report

Posted on by cholopa

I would like to make a connection to a database I created in Common Data Service so I can use the data in an excel sheet.

Notice I don't want to administrate the database (create, delete or modify the data..), I just want to read the data and auto fill some cells with the data from the database

Is there a way to to this?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

cholopa 62 on at

Like (0)

Report
Copy link

Link copied!

I think there is a way to do this using "Microsoft Powerapps office Add-in", I've been able to download the complement and stablish a connection with my account in office 365, but think I still can't access the data in Excel, (though I'm loggesd as administrator):

Any clue?

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like (0)

Report
Copy link

Link copied!

Hi @cholopa
As far as I know CDS has not yet been exposed to Excel's Power Query. This would be the natural way to use the CDS data in Excel. I think there already is an idea on this that you can vote up.

Was this reply helpful? Yes No
cholopa 62 on at

Like (0)

Report
Copy link

Link copied!

Hi:

Thanks for the reply.

I sort it out, it can be done, you just need to add the appropiate table in the design mode and select the table to want to access.

Was this reply helpful? Yes No
C. Marquardt 4 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I have the same problem. Can you descirbe your sollution a little bit in detail. Thank you.

Was this reply helpful? Yes No