Forum Discussion

Cnoseworthy's avatar
Cnoseworthy
New Member
9 years ago
Solved

box.com

Hi there!   I am a new user of Power BI and I am wondering if I can connect to an excel document I have stored on Box.com as a source of data.  I see sharepoint, and one drive - but no option for B...
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    You should be able to do this in the Desktop but not aware of a way to do that in the service. I tried this in the service by selecting "Local File". It it allows me to connect to the file, prompted for user name and password (I used a Share link) but then it tells me that the file type is not supported (it is an Excel file and Excel files are supported). I then tried this in the Desktop and it pulled it in OK but seemed to bring it in as a web page XML document. So...use OneDrive?

Edmond_Wabwire's avatar
Edmond_Wabwire
New Member
1 year ago

Hi Cnoseworthy,

 

I hope this is not so late as you try to find the solution to above hitch you are facing:

 

You could consider using BOX offline space to connect xls direct to BI i.e;

 

Get Data, Excel, on local PC search for BOX and connect to relevant file as this creates a live connection to the data even though it is offline. 

 

Prequisites: You need to install BOX and sign in, in your account. 

 

Thank you!