Excel Online not working in PBIRS

[JJones1505]

We downloaded and installed the PBIRS preview for August.  Pbix files work as do RDL reports.  I can upload Excel files as well. We also installed OOS on the test PBIRS server and configured using http. The issue I have is when i click to open the Excel file, I receive an error: "Unable to Open the file. We couldn't find the file you wanted. It's possible the file was renamed,moved or deleted."  The file was not any of these suggestions.  It is where I specified on upload.  I have searched for this issues but i get info related to SharePoint, which this is not.  What am I missing?  Thanks!

[jbeauche]

No. I've put O in upper case as an example (have to hide the real url) . It is not a special character. 

To answer the previous question, here what I've found:

<form name="office_form" class="ng-pristine ng-valid" id="office_form" action=" https://ab-cdef12.ghi.klmn/x/_layouts/xlviewerinternal.aspx?WOPIsrc=http%3A%2F%2Fsm-dapp96%3A80%2Fwopi%2Ffiles%2Fde99c5a3-9273-4599-a7d1-8c8f5e4cdb82&amp;ui=fr-FR" method="post" target="office_frame">
            <input name="access_token" type="hidden" value="m+hMpOGOnYIXCYbAtv5cvvyTPVexeU5M2/vkqVylW0FxR5XVA65trJNFPfhVI7UfRBdNIlDhWLGEekFaQlvZe+3QkF6q311hOMYsUbbQ5W8aVT/RAigQeY7Tmwhc59EKoXYfTzsuo5amOcw7ZbPvZobRlurfy54b6/5PLMYqgXxltrG4H6XvyMupOPfSHOkkUex+4Wf1TNLXL4p7UFSz93nibLO0ifzQxWyfurCg7e7vrulu8H0kvVqE8KnyEJNT8fc+PtaziQORb7DkHj8qSLv1uZiW3F6EIs/kxMztmPME/MxIPCmICV1AvuRrw1ER2nVjSRzhbDIiYCo35LI47EKSVVTYmWKHt2DodCNjDIEVXeDrl95MdOh22ChreSCBkYo/A5uU2LqgGy727A3o00ZoJddIHOV2nNJnCjseiM4Ww6L6XpDOzQ==">
            <input name="access_token_ttl" type="hidden" value="0">
        </form>
 
 
 
 Discovery document:

<action name="view" urlsrc=" https://ab-wxyz89.ghi.klmnO/x/_layouts/xlviewerinternal.aspx?<ui=UI_LLCC&><rs=DC_LLCC&><dchat=DISABLE_CHAT&><IsLicensedUser=BUSINESS_USER&>" default="true" ext="xlsx"/>
 

Please note that SharePoint Server is on a separate server in the same Domain.

PBIRS server :  https://ab-cdef12

SharePoint server: https://ab-wxyz89

It is truncated only in PBIRS. But in the PBIRS setting page, the full url not truncated is there. 

Thanks for your help.

[valentiniliescu]

What is the URL of the Office Online Server? https://ab-wxyz89 or https://ab-cdef12?

[jbeauche]

Sorry for the confusion

https://ab-wxyz89 is for Office Online Server

https://ab-cdef12  is for PBIRS

and
https://ab-rstu34 is for SharePoint Server

OOS is on a separate server than SPS.  From SPS we can render an Excel document using the same OOS as we are trying with PBIRS

[valentiniliescu]

To make sure I got it correctly:

https://ab-wxyz89.ghi.klmnO is the full URL of Office Online Server

https://ab-wxyz89.ghi.klmnO/hosting/discovery is the Office Online Server discovery URL, which is what was input in the PBIRS Site Settings

The discovery document contains this
<action name="view" urlsrc="https://ab-wxyz89.ghi.klmnO/x/_layouts/xlviewerinternal.aspx?<ui=UI_LLCC&><rs=DC_LLCC&><dchat=DISABL...>" default="true" ext="xlsx"/>

The form is of format:
<form name="office_form" class="ng-pristine ng-valid" id="office_form" action="https://ab-wxyz89.ghi.klmn/x/_layouts/xlviewerinternal.aspx?WOPIsrc=http%3A%2F%2Fsm-dapp96%3A80%2Fwo..." method="post" target="office_frame">

So basically, all of them should have the same URL (https://ab-wxyz89.ghi.klmnO) but the last one is actually missing the last character.

Am I right?

[jbeauche]

Yes you're right.

I imported an Excel document into a folder in PBIRS. Then I click on the Excel document to run it I've received the following error:

"The page cannot be displayed
Check the Web address https://ab-cdef12.ghi.klmn is correct"

where the O is missing in the url in the error message... and the setting is correct in PBIRS: https://ab-wxyz89.ghi.klmnO/hosting/discovery

And looking in the HTML source code I can see it's truncated:

<form name="office_form" class="ng-pristine ng-valid" id="office_form" action=" https://ab-cdef12.ghi.klmn/x/_layouts/xlviewerinternal.aspx?WOPIsrc=http%3A%2F%2Fsm-dapp96%3A80%2Fwopi%2Ffiles%2Fde99c5a3-9273-4599-a7d1-8c8f5e4cdb82&amp;ui=fr-FR" method="post" target="office_frame">

The Excel document can't be rendered within PBIRS

Thanks again!

[valentiniliescu]

Can you post the internal and external URLs (obfuscated, of course) for Office Online Server?

Go to the OOS machine and run this PowerShell command: Set-OfficeWebAppsFarm

This will list a lot of settings, but I am interested only in InternalURL and ExternalURL

[jbeauche]

On the OOS server both InternalURL and ExternalURL are identical:  https://ab-wxyz89.ghi.klmnO

Not truncated...

I don't understand why the PBIRS seems to truncate the OOS Discovery Endpoint URL settings before trying to call the OOS server.

Thanks!

[valentiniliescu]

Thank you for your support! You should contact Microsoft support and open a ticket.

[chrisfin]

If it's on the same machine, can you try using localhost vs. that URL?  Also, do you have the external URL configured?  You could try that as well.  Also, if you are using a self-signed certificate, you need to make sure it is trusted on the server for the connection to work properly.

We'll look at the URL dropping a character - seems a little odd, obviously.