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 Box.

 

Any info would be greatly appreciated!

 

Thanks!

  • 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?

13 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    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?

    • jrzytorr's avatar
      jrzytorr
      Regular Visitor
      6 years ago

      it did not worked for me, the pop up window of "The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server". close the window and gone to "data source settings" and tried all possible convinations but could not access to the excel file stored in box. error dosplayed

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      How are you able to connect to Box file from Power BI Desktop?

       

      It doesn't work for me.

  • Surajs's avatar
    Surajs
    New Member
    6 years ago
    When can box connector will be available on PowerBi. Tablaeu is providing the box connector.
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Still same error as of today 4/23. Details: "The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server."

  • cfredericks's avatar
    cfredericks
    New Member
    7 years ago

    I have no issue with uploading the content from box, I found that it works well if they both are in a shared box folder for refreshing. 

     

    I am though having issues when I try to open the same report on the the box mobile app which seems to be a huge issue

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks for the response.

       

      Which connector do you use in power BI to get data from box?

       

      My issue is that when I use Web connector and provide the Box link, the page read is of my single-sign on instead of the actual file.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Anonymous did you get the answer for this? I have same problem.

  • 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!