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.
I have been struggling for weeks trying to resolve an error I am receiving when refreshing my dataset via a gateway (on-prem or personal). Everything works fine from Power BI Desktop, but when published to the service and updated via demand or scheduled refresh, I get the following error:
Last refresh failed: Fri Oct 20 2017 08:14:26 GMT-0500 (Central Daylight Time)
Cannot connect to the mashup data source. See error details for more information.Hide details
Underlying error code: | -2147467259 Table: Story Burndown. |
Underlying error message: | [Unable to combine data] Section1/Story Burndown/AutoRemovedColumns1 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. |
DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
Microsoft.Data.Mashup.MashupSecurityException.DataSources: | [{"kind":"Web","path":"https://jira.jci.com:8443/rest/api/2/search"}] |
Microsoft.Data.Mashup.MashupSecurityException.Reason: | PrivacyError |
Cluster URI: | WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net |
Activity ID: | 52ac6557-e350-2b3f-8a7f-75b95b00c701 |
Request ID: | 786227e5-202b-7dd2-1247-5d29cc44ba81 |
Time: | 2017-10-20 13:14:26Z |
The short description is that I have a table that is built from multiple function calls - one that retrieves a date from a table in the model, and another recursive series which executes a Web.Contents call to a REST api for Jira. In the illustration below, the Story Burndown table attempts to retrieve a StartDate via the #activeSprintStartDate function prior to passing that date to the #"Status burndown chart" function. This scenario results in the aforementioned error. If I hard-code the date (see purple text below), the gateway refresh works fine.
I am seeking advice on how I can separate the calls any further to prevent the error from occuring.
Thank you in advance,
Ross
Solved! Go to Solution.
Much to my dismay, the promised gateway changes that were expected to address this failed to do so and my specific issue was ultimately deemed by Microsoft as unsupported by the gateway. My workaround was to completely redesign my approach to identifying the reporting period in a less than ideal hack.
Isso vai ocorrer sempre que tiver uma nova atualização do gateway. Token expirado.
Token é mesmo que autenticação - credenciais nestá situação.
Atualize seu gateway e em seguida você precisará reautenticar as credenciais na conexão do gateway (nos gateways do gerenciador no serviço do Power BI) .
I'm having the exact same problem as this, did you manage to find a solution?
Much to my dismay, the promised gateway changes that were expected to address this failed to do so and my specific issue was ultimately deemed by Microsoft as unsupported by the gateway. My workaround was to completely redesign my approach to identifying the reporting period in a less than ideal hack.
This is still an issue. We're receiving the same error today.
Gateway and Power BI desktop are both updated.
Hi all,
I had a call with Microsoft, they asked me to put privacy level to PRIVATE in the desktop, re-publish, then set privacy = PRIVATE in the PBI online service too (in the gateway settings we're using).
It solved the issue.
Cheers,
F.
Thanks for your response. I changed the privacy level on the desktop and cloud and it worked. (from organizational to private)
fhendrick's solution worked for me. Error I had was: "Microsoft.Data.Mashup.MashupSecurityException.Reason"
(edited for clarity)
Hi, I have tried this with Organisational as my privacy but it does not work. should i go and try with Private ? Also, below is my error message in service to refresh the datasource.
Underlying error message: | [Unable to combine data] Section1/Actual_Ordered Speed/AutoRemovedColumns1 is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination. |
DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
Microsoft.Data.Mashup.MashupSecurityException.DataSources: | [{"kind":"SQL","path":"Test;Test"},{"kind":"Web","path":"pathofmyurl"}] |
Hope to get some helpful answer on this !!!.
I also have a mashup error on some of my refresh in powerbi service with my gateway (i have a cluster of 3 servers).
The 3 nods on my cluster were update last week with the last version of the gateway.
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Anyony can help?
Hi I had the same problem.
I got message: UnderlyingErrorMessage","detail":{"type":1,"value":"Information is needed in order to combine data"}}
And it was connected to how I combine the data. In power query I couldnt merge data form table (data from computer disc C) and form different table (form jira or from sharepoint) even privacy level was the same.
I just didnt merge this data in power query, I did it in DAX by "related", and then refresh is working ok.
A new version was released today. Maybe that will fix it as it seems it was out of sync with he desktop version prior to the update. https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-october-update-is-now-available/
I have updated to the latest versions of all components with no change in results.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |