Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

andrecxl

refresh issues with on prem data gateway

Submitted by on ‎02-07-2023 04:11 PM

i have been using on prem data gateway for years and it worked fine until 2PM yesterday (Feb 6)

 

uninstalled, reinstalled, reconfigured data gateway but issues persist

 

however, no issue when the same dataset is refreshed manually using power bi desktop

 

Power BI Support team - can you please help? thanks

Status: Accepted

Hi @andrecxl ,

 

We have reported this issue and submitted it to the product team.
They have been aware of the issue and the engineers will do their best to resolve it. I will update here if there is any progress, so please be patient. 

 

Best regards.
Community Support Team_ Caitlyn

See more ideas labeled with:
5 Comments (5 New)
Comments
andrecxl
New Member
‎02-07-2023 04:13 PM

here is what the error i get

 

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_TimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_TimeoutError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: Budget.

andrecxl
New Member
‎02-07-2023 05:12 PM

additional info

 

Cluster URI: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID: c246ca77-e1d6-4f4e-a07c-91cdb01a65e7
Request ID: 579b3dff-a305-374b-6459-9f2ed3c332b6

v-xiaoyan-msft
Community Support
Community Support
‎02-09-2023 07:29 AM
Status changed to: Accepted

Hi @andrecxl ,

 

We have reported this issue and submitted it to the product team.
They have been aware of the issue and the engineers will do their best to resolve it. I will update here if there is any progress, so please be patient. 

 

Best regards.
Community Support Team_ Caitlyn

MarcusBD
Regular Visitor
‎02-14-2023 01:41 AM

Same problem here since last week. In our case it is reproducible:
Power Bi report with 2 datasources
* one excel file on sharepoint
* one on-premise SQL database
The problem arises when merging the 2 datasources, without merging refreshing via the gateway goes fine (desktop refresh is without problems in either case).
It looks like another issue:

Gateway data refresh fails when data is merged fro... - Microsoft Power BI Community

theadventurer
Frequent Visitor
‎02-21-2023 05:33 PM

22 Feb 2023 - This issue is resolved now - all the dataflows started working fine.

 

Hi @v-xiaoyan-msft,

 

I get the below error when refreshing the dataflow - the error started on my scheduled refresh on 21 Feb 2023, all the dataflows refreshed fine before that date. I uninstalled the old gateway and installed the latest gateway version 3000.162.9 but still the dataflows won't refresh and shows the error below. I tried creating new dataflow and creating the queries again but once i refresh the data - it gives me the error. Please note all the queries work find in Power BI desktop.

 

Error:
Couldn’t refresh the dataflow because the on-premises data gateway was not found and might have been deleted. Please attach the dataflow to a different gateway and try again. Request ID: f3c54f96-a49e-722d-d26e-6d227c52f794 Activity ID: 126692e8-4294-4584-81f9-80fed72f3b75

Idea Statuses