Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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&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.
What is the URL of the Office Online Server? https://ab-wxyz89 or https://ab-cdef12?
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
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?
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&ui=fr-FR" method="post" target="office_frame">
The Excel document can't be rendered within PBIRS
Thanks again!
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
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!
Thank you for your support! You should contact Microsoft support and open a ticket.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
14 | |
10 | |
5 | |
3 | |
3 |