Тип clr microsoft mashup engine1 runtime value exception не поддерживается
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 report for the first time received the following error:
My 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 all reports.
Ответы
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 he needs.
- Изменено Ehren - MSFT Microsoft employee 26 марта 2019 г. 20:21
- Предложено в качестве ответа Ehren - MSFT Microsoft employee 1 апреля 2019 г. 22:48
- Помечено в качестве ответа Ehren - MSFT Microsoft employee 29 апреля 2019 г. 18:40
Все ответы
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 he needs.
- Изменено Ehren - MSFT Microsoft employee 26 марта 2019 г. 20:21
- Предложено в качестве ответа Ehren - MSFT Microsoft employee 1 апреля 2019 г. 22:48
- Помечено в качестве ответа Ehren - MSFT Microsoft employee 29 апреля 2019 г. 18:40
So is it possible that I am getting this error because I am using two different accounts, one for Azure and another for Power BI?
I'm also experiencing the same issue, though here, all users use the same account on Azure and Power BI.
Hi Renato. I'd recommend using a tool like Fiddler to see which web request is failing, and if there's any info on the response that indicates why the failure is occurring.
This happens on files that are shared on Sharepoint with Autosave ON. This is how I solve it everytime. Go to Powerquery File>Options and Settings>Data Source settings>Global Permissions. Delete the Global permissions and close the dialog boxes. Refresh the file again and it will ask for your credentials again and it will work.
Hi hkaush. Can you send me a private message on the Power BI Community?
We'll likely need to you gather a Fiddler trace when this occurs, so we can see what's happening in our communication with SharePoint.
Did you find something? I have the same issue with an Excel file in SharePoint that use PowerQuery to extract data from SharePoint.
In my case, I needed to validate my Office 365 organizational login on the computer I was using for the specified data source.
I have same problem. my work mate get this error when he tries to refresh query. It does not show login screen like it should.
i have to reset permissions from Query options and login screen will be displayed. When hi uses his own credentials he after permission reset everything goes like it should.
But next day it will splash the error screen again, and no login screen? Other team members do not have this problem?
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 refreshed because 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,
P.S. As a feedback I'm verry disapointed because it happens to often to discard my changesd when i'm trying to save. I recognize that it's a verry used excel , but i didn't expect to have this kind of problem so often. If i knew it i would prepare it a macro to do the job of sending and receving the data in database.
Unexpected error: Specified value has invalid CRLF characters.
Parameter name: value
Microsoft.Mashup.Evaluator.Interface.ErrorException: Specified value has invalid CRLF characters.
Parameter name: value ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Specified value has invalid CRLF characters.
Parameter name: value ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Specified value has invalid CRLF characters.
Parameter name: value ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Specified value has invalid CRLF characters.
Parameter name: value ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Specified value has invalid CRLF characters.
Parameter name: value ---> System.ArgumentException: Specified value has invalid CRLF characters.
Parameter name: value ---> System.ArgumentException: Specified value has invalid CRLF characters.
Parameter name: value
at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.BuildWebRequest(IResource origin, Uri uri, IResource& resource)
at Microsoft.Mashup.Engine1.Library.Web.Request.ManualRedirect(IEngineHost host, String resourceKind, Uri uri, CreateWebRequestDelegate createRequest, Func`2 createResponse, WebRequest& webRequest, Int32[] nonErrors)
at Microsoft.Mashup.Engine1.Library.OData.ODataRequest.GetResponseStream(IHostTrace trace, String key, Boolean tokenRefreshed)
at Microsoft.Mashup.Engine1.Library.OData.ODataFallbackVersionHandler.HandleVersionFallback[T](Func`1 function, Boolean throwOnBadRequest)
at Microsoft.Mashup.Engine1.Library.OData.ODataModule.FeedFunctionValue.TypedInvoke(TextValue serviceUri, Value headers, Value options)
at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame0& frame)
at Microsoft.Mashup.Engine1.Language.LanguageLibrary.Evaluate(String text, Value environment, IEngineHost engineHost, Module[] modules)
at Microsoft.Mashup.Engine1.Library.SharePoint.SharePointModule.EvaluateSP15(String m, IEngineHost host)
at Microsoft.Mashup.Engine1.Library.SharePoint.SharePointModule.CreateSharePoint15TableValue(IEngineHost host, IResource resource, String url, FolderOptions enumeration, ResourceCredentialCollection credentials, Boolean versionMatch)
at Microsoft.Mashup.Engine1.Library.SharePoint.SharePointModule.CreateTableValue(IEngineHost host, TextValue url, FolderOptions enumeration, Value options)
at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.FieldAccessInstruction.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.Instruction.ExecuteCondition(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.DebugInstruction.ExecuteCondition(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.IfInstruction.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
at Microsoft.Mashup.Evaluator.FirewallPartition.BeginGetResult[T](Action`1 callback)
at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.Evaluation`1.OnBufferComplete(Exception exception)
at Microsoft.Mashup.Evaluator.Firewall.BeginBufferPartitions(Action`1 callback)
at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.BeginGetResultInternal[T](DocumentEvaluationParameters parameters, Action`1 callback)
at Microsoft.Mashup.Evaluator.Interface.IDocumentEvaluatorExtensions.GetResult[T](IDocumentEvaluator`1 evaluator, DocumentEvaluationParameters parameters)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.b__0(Object o)
at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)
at Microsoft.Mashup.Container.BootstrapAppDomainManager.Execute(String[] argv)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__DisplayClass3_0.b__0(EvaluationResult2`1 result)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__DisplayClass3_0.b__0(EvaluationResult2`1 result)
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
at Microsoft.Mashup.Evaluator.FirewallPartition.BeginGetResult[T](Action`1 callback)
at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.Evaluation`1.OnBufferComplete(Exception exception)
at Microsoft.Mashup.Evaluator.Firewall.BeginBufferPartitions(Action`1 callback)
at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.BeginGetResultInternal[T](DocumentEvaluationParameters parameters, Action`1 callback)
at Microsoft.Mashup.Evaluator.Interface.IDocumentEvaluatorExtensions.GetResult[T](IDocumentEvaluator`1 evaluator, DocumentEvaluationParameters parameters)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.b__0(Object o)
at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)
at Microsoft.Mashup.Container.BootstrapAppDomainManager.Execute(String[] argv)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.b__0(Object o)
at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)
at Microsoft.Mashup.Container.BootstrapAppDomainManager.Execute(String[] argv)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
at Microsoft.Mashup.Evaluator.Message, Action`1 action)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)
This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.
I created several queries importing data from the files stored in the organizational sharepoint.
I can refresh the queries without any issue. However others which are also the member of the shreapoint cannot refresh the queries and they are getting the following message:
microsoft.mashup.engine.interface.resource access forbiddenexception
I saw other thread related to this issue and tried to delete the data source setting and set the permission as organizational, but this doesn't solve the issue.
I really need the advise to solve this issue. thanks.
This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.
Report abuse
Harassment is any behavior intended to disturb or upset a person or group of people. Threats include any threat of suicide, violence, or harm to another. Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity. Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect. Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software. Unsolicited bulk mail or bulk advertising. Any link to or advocacy of virus, spyware, malware, or phishing sites. Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct. Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation.
Replies (2)
Thanks for posting the thread on our forum.
From your description, it seems that you get data from a site list in SharePoint. If yes, I'd like to confirm whether you get the data from SharePoint Online or SharePoint Server.
About "However others which are also the member of the shreapoint cannot refresh the queries and they are getting the following message: microsoft.mashup.engine.interface.resource access forbiddenexception", I'd like to confirm whether all members in the site are experiencing the issue in their Excel applications except you.
If you do a test in another site list in another site, will the issue happen? I'd like to confirm whether the issue only occurs in the specific site list in the specific site.
Given the situation, as you have made sure that credential they used are organizational account, I suggest you check whether they are using the latest version of the Excel applications and upload a full screenshot of the Account page in the Excel applications they are using for our reference. You can access the page via clicking on File>Account.
Note: Remove any private information before uploading the screenshot.
Meanwhile, I suggest you let them log into their computers with the administrator accounts>go to Control Panel>Programs>right-click on the Office applications' icon>Change>check whether there is an Online Repair option. If yes, run it, restart the computer and then do a test to see the result.
* Beware of scammers posting fake support numbers here.
* Once complete conversation about this topic, kindly Mark and Vote any replies to benefit others reading this thread.
Report abuse
Harassment is any behavior intended to disturb or upset a person or group of people. Threats include any threat of suicide, violence, or harm to another. Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity. Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect. Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software. Unsolicited bulk mail or bulk advertising. Any link to or advocacy of virus, spyware, malware, or phishing sites. Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct. Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation.
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 report for the first time received the following error:
My 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 all reports.
Answers
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 he needs.
- Edited by Ehren - MSFT Microsoft employee Tuesday, March 26, 2019 8:21 PM
- Proposed as answer by Ehren - MSFT Microsoft employee Monday, April 1, 2019 10:48 PM
- Marked as answer by Ehren - MSFT Microsoft employee Monday, April 29, 2019 6:40 PM
All replies
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 he needs.
- Edited by Ehren - MSFT Microsoft employee Tuesday, March 26, 2019 8:21 PM
- Proposed as answer by Ehren - MSFT Microsoft employee Monday, April 1, 2019 10:48 PM
- Marked as answer by Ehren - MSFT Microsoft employee Monday, April 29, 2019 6:40 PM
So is it possible that I am getting this error because I am using two different accounts, one for Azure and another for Power BI?
I'm also experiencing the same issue, though here, all users use the same account on Azure and Power BI.
Hi Renato. I'd recommend using a tool like Fiddler to see which web request is failing, and if there's any info on the response that indicates why the failure is occurring.
This happens on files that are shared on Sharepoint with Autosave ON. This is how I solve it everytime. Go to Powerquery File>Options and Settings>Data Source settings>Global Permissions. Delete the Global permissions and close the dialog boxes. Refresh the file again and it will ask for your credentials again and it will work.
Hi hkaush. Can you send me a private message on the Power BI Community?
We'll likely need to you gather a Fiddler trace when this occurs, so we can see what's happening in our communication with SharePoint.
Did you find something? I have the same issue with an Excel file in SharePoint that use PowerQuery to extract data from SharePoint.
In my case, I needed to validate my Office 365 organizational login on the computer I was using for the specified data source.
I have same problem. my work mate get this error when he tries to refresh query. It does not show login screen like it should.
i have to reset permissions from Query options and login screen will be displayed. When hi uses his own credentials he after permission reset everything goes like it should.
But next day it will splash the error screen again, and no login screen? Other team members do not have this problem?
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 refreshed because 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,
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 report for the first time received the following error:
My 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 all reports.
Answers
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 he needs.
- Edited by Ehren - MSFT Microsoft employee Tuesday, March 26, 2019 8:21 PM
- Proposed as answer by Ehren - MSFT Microsoft employee Monday, April 1, 2019 10:48 PM
- Marked as answer by Ehren - MSFT Microsoft employee Monday, April 29, 2019 6:40 PM
All replies
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 he needs.
- Edited by Ehren - MSFT Microsoft employee Tuesday, March 26, 2019 8:21 PM
- Proposed as answer by Ehren - MSFT Microsoft employee Monday, April 1, 2019 10:48 PM
- Marked as answer by Ehren - MSFT Microsoft employee Monday, April 29, 2019 6:40 PM
So is it possible that I am getting this error because I am using two different accounts, one for Azure and another for Power BI?
I'm also experiencing the same issue, though here, all users use the same account on Azure and Power BI.
Hi Renato. I'd recommend using a tool like Fiddler to see which web request is failing, and if there's any info on the response that indicates why the failure is occurring.
This happens on files that are shared on Sharepoint with Autosave ON. This is how I solve it everytime. Go to Powerquery File>Options and Settings>Data Source settings>Global Permissions. Delete the Global permissions and close the dialog boxes. Refresh the file again and it will ask for your credentials again and it will work.
Hi hkaush. Can you send me a private message on the Power BI Community?
We'll likely need to you gather a Fiddler trace when this occurs, so we can see what's happening in our communication with SharePoint.
Did you find something? I have the same issue with an Excel file in SharePoint that use PowerQuery to extract data from SharePoint.
In my case, I needed to validate my Office 365 organizational login on the computer I was using for the specified data source.
I have same problem. my work mate get this error when he tries to refresh query. It does not show login screen like it should.
i have to reset permissions from Query options and login screen will be displayed. When hi uses his own credentials he after permission reset everything goes like it should.
But next day it will splash the error screen again, and no login screen? Other team members do not have this problem?
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 refreshed because 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,
Читайте также: