Forum Discussion
mashup data source error in gateway (only) refresh
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
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.
13 Replies
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/
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.
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) .
