Forum Discussion
PowerApps attachments as datasource
Hi all
I have been working on a project where we want to combine the Input from PowerApps with Power BI's reporting.
The problem I am currently encountering is using Excel workbooks of type .xlsx that were uploaded using PowerApps as a datasource for Power BI.
Since these files are uploaded into SharePoint, I thought of pointing to the list containing these uploads and it returned to site URL for downloading the file.
Is there some way to use this URL - or any alternative - to connect to the uploaded worksheets using Power Query?
Hello Anonymous
I think it should work like this
Excel.Workbook(Web.Contents(YOURPATHFROMPOWERAPP))
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
6 Replies
Hello Anonymous
I think it should work like this
Excel.Workbook(Web.Contents(YOURPATHFROMPOWERAPP))
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
JimmyThanks Jimmy801 this seems to work for pointing to a single file.
Do you have any suggestions on how I can append the data of multiple files like they are stored in my example?
I tried playing around with the SharePoint.Contents and SharePoint.Files data access functions, but with no success.
Hello Anonymous
I'm not an expert, but I think there is a difference in Sharepoint and Sharepoint online. And It could also be that your administrator somehow blocked the access of streaming services like Power BI. How I said, I'm not an expert.
I've tried with this function, and it works
= SharePoint.Contents("YOUSHAREPOINT", [ApiVersion = 15])
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy