Salesforce Reports - Access to the Resource is forbidden

[Andshepch]

Hi all,

I have an extremely frustrating problem that might actually be a showstopper with regards to IMplementing Power BI across my organisation. I have been responsible for developing a number of dashboards for the company, combining Salesforce Reports and Excel files hosted on Sharepoint online. Now we are trybing to move into production phase and other colleagues now need to be able to make changes to the Dashboards, as I can't do it all.

We have reports/datasets that I have published to the cloud and work fine (Scheduled Refresh etc) - but when another colleague tries to download and edit the PBIX files in Desktop they keep getting "Access to the resource is forbidden" from the Salesforce reports - despite all of these colleagues having access rights to the reports/folders in Salesforce. We have looked at the Data source settings in their Power BI desktop (Global and Current file) logged out, logged in etc. with no problem, using our company credantials, and Power bi Says that they are logged in fine to both Salesforce and to Sharepoint, but we keep getting this error.

We have invested a lot of time in Training and design of dashboards, but if we can't overcome this it might be the end for Power BI for us, so I would be really greatful if anyone has any ideas of what we might try.

Thank you

Andrew

[v-danhe-msft]

Hi @Andshepch,

From your description, where your colleagues want to modify your report? Could you mean that you have published your report to the PBI service or just connect to the saleforce in power bi service?

Could your colleagues edit your report in the service?

Also please ensure that your colleagues have modified credentials, you could go to File->Options and Settings->Data Source Settings, find the Salesforce data source, click “Edit permissions” to change credential.

Regards,

Daniel He