Connection PowerApps - Alteryx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have an excel file that is the output of an Alteryx flow. This excel must be read for a PowerApps application but every single time I run the Alteryx flow the below error raises:
You don't have permission to view this data. Server Response: Table1 failed: The request is forbidden by Graph API. Error code is 'AccessDenied'. Error message is 'Could not obtain a WAC access token.
The Alteryx flow is very simple, It just takes an excel file and convert it into a table format by a python code.
After that, the power apps must connect to this excel file but, regrettably, that error appears.
¿some ideas for solution, please?
thanks.
- Labels:
- Error Message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @Gego ,
I don't know the answer to why this is not working, I've not seen this before, but I'd start to work this through in the following order:
- Can you open this excel file from excel on your desktop (the same desktop that uses Alteryx) - if not then this feels like it may be a permission error with your office 365 infra; or your network infr.
- If you can open up the excel file on your desktop - then can you move it to a folder that you know for a fact is safe and accessible to your Alteryx (e.g. c:\temp). That way you can eliminate network stuff
- if you have full access to the file and it's still struggling - then I'd check if this file has any embedded code or data sources. Easy way to check this is to copy just the data out into a new spreadsheet and try this Alteryx flow on this stripped down flow.
- You can check if this is something wrong with your excel drivers by changing this to a CSV file and trying again
Hope you find the solution - when you do, would you post it here so that this can become part of the body of knowledge?
Good luck @Gego
Sean
