topic Read from dataset using REST API in Developer

Read from dataset using REST API

v-pn — Tue, 10 Jul 2018 03:55:14 GMT

Hello - I have a organization published content pack. I need to be reading the dataset to get some data that i need in my D365 CRM system. Is there a way to read it using the REST API ? I tried to access it and ended up seeing a 404 not found error

Re: Read from dataset using REST API

v-jiascu-msft — Wed, 11 Jul 2018 02:55:13 GMT

Hi @v-pn,

I'm afraid we can't do that for now. Please refer to en-us/rest/api/power-bi/datasets and vote up this idea.

Why not intergrating Power BI directly? Please refer to dev-itpro/analytics/power-bi-integration and library/dn708055.aspx#Anchor_2.

Best Regards,

Dale

Re: Read from dataset using REST API

v-pn — Wed, 11 Jul 2018 02:58:49 GMT

Thanks Dale - so i need the ability to read the data into the CRM system and do not necessarily need to create a report here. Essentially the manual export that i do on a pbix report needs automation.

Re: Read from dataset using REST API

v-jiascu-msft — Wed, 11 Jul 2018 03:03:53 GMT

Hi @v-pn,

How about connecting to the source directly?

Best Regards,

Dale

Re: Read from dataset using REST API

v-pn — Wed, 11 Jul 2018 03:05:53 GMT

That is not an option at the moment. I think it just circles back to a similar question asked sometime ago noting that the datasource would have multiple transformations on the data and what i see on the pbix is essentially the transformed data. It would be redundant to do the same process over again.