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: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

0
TonyGu

Dataset Refresh Issue. Dataset requires gateway

Submitted by Helper I on ‎09-05-2023 10:53 AM

HI, I have a couple of Desktop files which when published to service, the dataset doesn't refresh as it requires a gateway. eventhough it's all cloud sources. I have created several other desktop files in the past with the same query structure and none of them has had any issues. Below is the error message as well as screenshot showing all cloud sources (The web sources are route to sharepoint files. I have masked the hyperlinks)

 

Refresh failed because this dataset requires a gateway. Please select a gateway from dataset settings.

 

Is it okay to post the Activity ID, Request ID and Correlation ID here??

 

TonyGu_0-1693936225236.png

TonyGu_1-1693936321155.png

 

 

 

Status: Delivered
See more ideas labeled with:
6 Comments (6 New)
Comments
Anonymous
Not applicable
‎09-05-2023 06:25 PM

Hi @TonyGu ,

Why not use the Power BI Desktop built-in SharePoint connector?

 

Best regards,
Community Support Team_Binbin Yu

TonyGu
Helper I
Helper I
‎09-06-2023 09:00 AM

Hi Binbin Yu, 

 

My bad, I'm using the Excel Workbook connector, but using the sharepoint link so it stays as cloud source. I've cloaked the org number and file path, but looks something like this on desktop 

 

TonyGu_0-1694015872662.png

 

I could use the Sharepoint connector where it goes to the root folder and I can naviagte into the relevant directory from there. But would have to change quite a few desktop files. I have several others that are working right now, would I have to change those as well? 

 

Anonymous
Not applicable
‎09-08-2023 12:50 AM

Hi @TonyGu ,

I'm a little confused about your needs, Could you please explain them further?

 

Best regards,
Community Support Team_Binbin Yu

TonyGu
Helper I
Helper I
‎09-12-2023 11:25 AM

Hi Binbin, 

 

I have changed all sharepoint sources into Dataflows to make things cleaner. Here is what it looks like right now 

TonyGu_0-1694543107024.png

 

Still dealing with the same issue.

Processing Error: There is no available gateway 

Request ID: 

828236f3-bfba-468a-a649-6fee2d36ae85

 

 

 

Alternatively, I have tried replacing all the POwer BI Legacy connectors with Power Platform Connectors and getting the same issue 

Processing error: There is no available gateway.
Request ID: f33f9453-2e30-4a63-862c-0d39aec59f31

TonyGu_0-1694623559597.png

 

 

 

 

 

To Clarify my previous statement, I have several datasets on the service that are using the Excel Workdbook connector. These refresh without issue. It's only the new datasets I'm publishing to new workspaces that are suddenly having this problem. So I was wondering what the root cause was and whether the older datasets would need to be updated?

TonyGu
Helper I
Helper I
‎09-18-2023 09:02 AM

I jus thad to map my cloud sources to Personal Cloud Connection. It's working now. You can close this ticket if you wish. Thanks

Anonymous
Not applicable
‎09-18-2023 07:13 PM

Hi @TonyGu ,

I am so glad to hear that you have fixed your issue . I will change the status to "Delivered".

 

Best regards,
Community Support Team_Binbin Yu

Idea Statuses