![](/uploads/1/2/7/8/127857001/744218214.png)
![Mashup 1 4 3 Fix Issues Mashup 1 4 3 Fix Issues](/uploads/1/2/7/8/127857001/366739524.jpg)
Hi there,I'm using PowerQuery to extract data from a couple of files held in a work Sharepoint folder which are then joined together using PowerPivot. I, the creator of the file can refresh the report with no issues, but my colleague who tried to refresh the reportfor the first time received the following error:Microsoft.Mashup.Engine.Interface.ResourceAccessForbiddenExceptionMy first thought is that it's something to do with his credentials, but he has the same access to the Sharepoint folders that I do and signed in through his Organisational account. I have set Data Source settings to Organisational or Public across allreports.Any ideas?
Based on our code, ResourceAccessForbiddenException is thrown by the M runtime when a permitted resource access (with or without credentials) results in an forbidden failure from the resource.In other words, it sounds like the data source is recognizing the credentials, but disallowing access to the person who is signed in. EDIT: It's also possible this error might be returned if the target server is throttling your connection.Could you try refreshing the data from his machine but entering your credentials? If that fails, it indicates there's some issue with running the queries from his machine. If it works, it indicates that he doesn't actually have the proper permissions heneeds.Ehren.
![Mashup 1 4 3 fix issues list Mashup 1 4 3 fix issues list](https://imagesvc.timeincapp.com/v3/fan/image?url=https://thelandryhat.com/wp-content/uploads/getty-images/2018/08/1198311792.jpeg&c=sc&w=3200&h=2134)
YouTube Mashup Tool Error. Blackboard knows about this bug, and will fix the Bb Grader App later in the summer. Workaround/Resolution for problems #1, #2, and #3: For existing Mac Recorder installations, upgrade to.
I faced something similar today, while trying to run a sentiment analysis on Power BI through Azure's Cognitive Services (As mentioned in this tutorial 'Tutorial: Integrate Power BI with the Text Analytics Cognitive Service')My data has 1000 Rows.I got the following error when I tried to represent the numeric values of sentiment as positive, negative and neutral by adding another column. I tried removing the column and that didn't fix the issue.' OLE DB or ODBC error: Exception of type 'Microsoft.Mashup.Engine.Interface.ResourceAccessForbiddenException' was thrown.' Based on our code, ResourceAccessForbiddenException is thrown by the M runtime when a permitted resource access (with or without credentials) results in an forbidden failure from the resource.In other words, it sounds like the data source is recognizing the credentials, but disallowing access to the person who is signed in. EDIT: It's also possible this error might be returned if the target server is throttling your connection.Could you try refreshing the data from his machine but entering your credentials? If that fails, it indicates there's some issue with running the queries from his machine.
If it works, it indicates that he doesn't actually have the proper permissions heneeds.Ehren. Hi,I have the same issue in Excel. Whenever a 'different' person opens the file, there is the error message 'Microsoft.Mashup.Engine.Interface.ResourceAccessForbiddenException'. The person who last saved the file doesn't have the issue.All the files are in the same SharePoint library. The main file contains several queries referring to other Excel files in the same library. We have to be loggued in to open the main file.
At the opening of the main file, the queries cannot be refreshedbecause of credentials.Work-around: cancel the refresh, go to Get Data/ Data Source Settings / Global Permissions / Clear all permissions. Then click on Refresh All, and the authentication windows pops-up. There we select 'Organizational account', then 'Sign in'and Connect. No need to enter password.This workaround is painful.
How to avoid it? There is no problem if the main file is in SharePoint and the other files are on a local folder or a share.Thanks,Sylvie.
Hi There,This might be an obvious trouble shooting step, but I've been able to rectify this by navigating into the power query environment, selecting the query, and click on data source setting, and edit the permission. I find that for some reason, the query willdefault to anonymous authentication. (even though I've previously set it to 'organisational account') and i just have to reset it back, authenticate with the new user, and then the query will run again.Again, this might be obvious, but it wasn't to me at first!hope it helps.
![](/uploads/1/2/7/8/127857001/744218214.png)