Single Excel Process Scope: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

Help Studio
1

Hi all,

I am trying to create a Power BI report from an excel report generated from UiPath process. After start process activity open’s up the power BI report and trying to click on refresh button in Power BI I get this error “Use Application: pbidesktop.exe: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))”

image
image745×735 37.5 KB

Also I checked and could understand that I do not have access to “C:\Program Files\WindowsApps\Microsoft.MicrosoftPowerBIDesktop_2.100.1401.0_x64__8wekyb3d8bbwe\bin\pbidesktop.exe”

Looking for a solution.
What shall be done in case I do not have access to WindowsApps\Microsoft.MicrosoftPowerBIDesktop??

If not PowerBI, Is there any other application where I can generate report with the excel data coming from UiPath???
Please help!!!

2

You can push data to Google Sheet (with UiPath GSuite package) and use Google Data Studio to create a dynamic dashboard.

3

Thank you Shubin but this RPA process/job is triggered through orchestrator in virtual machine which doesn’t have a google account. So I don’t think this will work in my case. Looking for Power BI report solution, will be good if any one can give inputs
Thanks

4

You don’t need Google Account on virtual machine. Google Account can be accessed with user name password in UiPath GSuite Package.

5

Hi @SwaCh

I used to get this error when an application trying to access the excel while it is already being used by another application.

In your case, power BI is trying to use excel when the same excel is opened by UiPath elsewhere.
Suggestion - try to close the excel programmatically before reaching to Power Bi step

6

Thanks for the response Aditya.
Here I’m not trying to open any excel application.
Steps in my RPA process:

  1. Start process activity (It will open pbix report from the given path. For example: XYZ.pbix)-----> Works well without error.
    2)Use application/browser activity (It will click on refresh button in XYZ.pbix Power BI report) -----> In this activity I get this error “Use Application: pbidesktop.exe: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))”

here I’m not opening any excel application nor doing any excel related activities.