Forum Discussion
Accessing Excel files from folder in Box drive.
Hi,
I have followed the below link to access the files in the box drive. I can able to access only one file.
But, the folder in box drive contatins daily operational reports in ".xlsx" format.
Can anyone help me out on how to access all the excel files from box in Power Bi.
https://community.powerbi.com/t5/Power-Query/box-com/m-p/119411#M7958
Thanks and Regards,
San R
3 Replies
- amitchandakSuper User
sudharsanr , please check if this can help
https://community.powerbi.com/t5/Power-Query/box-com/td-p/119392
or power flow
https://flow.microsoft.com/en-us/connectors/shared_box/box/
https://tray.io/connectors/box-microsoftpowerbi-integrations
- Greg_DecklerCommunity Champion
sudharsanr - Have you tried a Folder query pointing to that location? Folder queries are for importing multiple files within a folder and combining them into a single table.
- v-easonf-msftCommunity Support
Hi , sudharsanr
Can you share a related screenshoot?
What connector you are using?You can check if the thread in Box Support is helpful to you.
https://support.box.com/hc/en-us/community/posts/360049182014-Connect-Power-BI-to-files-in-BOX
Best Regards,
Community Support Team _ Eason