Unanswered

Access data through Odata feed using Excel or Power Query

(0) Share

Report

Posted on by Elowy GrootCRM

153

I would like to give customers access to their own data using an odata feed within the Power Portal. Of course the customer has to use a login to access the data. Did anyone tried this before?

I tried to connect to the odata feed using Excel / Power Query. Unfortunately I am not able to get access to the feed. Not with the basic login, nor with a organization login (AD login). Somehow an organization login isn't possible in Power Query with this type of feed.

Hope someone can help me!

Thanks a lot!

Best regards,

Elowy.

Categories:

Power Apps portals

I have the same question (0)

All responses (5)

Answers (0)

OOlashyn 3,496 Most Valuable Professional on at

Like (1)

Report

Hi @GrootCRM ,

Please do not use the OData option for Lists - it is not secure as it doesn't respect table permissions. In general, Portal is designed as a website to access data, not as an integration or data point.

Was this reply helpful? Yes No
Elowy GrootCRM 153 on at

Like (0)

Report

Hi @OOlashyn ,

Many thanks for responding. Can you explain this a little more, please? As far as I know, when checking "Enable table permissions", the permissions are being used. Or is there some kind of flaw I'm not aware of?
At this moment the users can login, view their data in a list, and click on download to get this data in Excel. Isn't this about the same as giving them Excel access through a (secure) odata feed?

Regards,
Elowy.

Was this reply helpful? Yes No
OOlashyn 3,496 Most Valuable Professional on at

Like (1)

Report

@GrootCRM , yes my bad - after last year's security problem MS started enforcing table permissions for odata as well. Force of habit 😃 But to enforce those table permissions webpage needs to know which user is currently logged in and I don't know how you can do that with Excel access.

Was this reply helpful? Yes No
Piper 177 on at

Like (1)

Report

Hi @GrootCRM,
I'm not 100% clear if this fits your use case so please keep that in mind.

You could create a Virtual Table in Microsoft Dataverse. Then you can surface that table in your portal and enable the appropriate table permissions. Be sure to check out the Limitations of Virtual Tables as well.
Thanks,
Piper

Was this reply helpful? Yes No
Elowy GrootCRM 153 on at

Like (1)

Report

Hi Piper,

Thanks for responding with a great suggestion. However, I now see that my question was not totally clear. Sorry about that...

I'm trying to give portal users access to the Dataverse data using odata and Power Query in stead of Portal lists. So they can make their own dynamic queries on the Portal data.

As long as the odata feed is not secured, this works well. But as soon as I try some kind of security (like AD or native login), I'm not able to connect to the feed anymore.

Thanks,
Elowy.

Was this reply helpful? Yes No