Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
rasmussen81
New Member

"There is no gateway available" error with report using Google Analytics and CSV file

Hi all,

 

I'm having trouble updating data in my Power BI report. The report contains two sources:

  • Google Analytics
  • CSV file on a fileshare

In Power BI Desktop there are no problems updating data. The Google Analytics data is retrieved from the cloud service and the CSV data is imported from the file. However, once I upload the report to the Power BI service and configure the CSV data source in my data gateway, I get an "There is no gateway available" error when I try to update the dataset. Everything looks fine in the data gateway settings and I have also doubled checked the CSV data source. Furthermore, I have tried to separate the two data sources into two reports and tested the refresh. This worked fine. So it seems like there might be a problem with the combination of the two data source and the refresh function. I'm thinking the problem might be related to the fact that the Google Analytics data isn't retrieved via the data gateway while the CSV data is. But I haven't been able to confirm this suspicion.

 

Has anyone had the same problem and possibly found a solution?

 

Best regards,

Rasmus

1 ACCEPTED SOLUTION
Anonymous
Not applicable

When you view "Manage Gateways" have you turned this option on?

 

Capture.PNG

View solution in original post

4 REPLIES 4
Thejeswar
Community Champion
Community Champion

Hi @rasmussen81,

As @Anonymous stated, there will be such setting that I think is applicable for the entire tenant which has to be checked to allow you to import data from CLoud data sources

Anonymous
Not applicable

When you view "Manage Gateways" have you turned this option on?

 

Capture.PNG

Hi Ross,

 

I'm pretty sure that option was checked but I just tried to uncheck and check it again and now it seems that my report can be refreshed.

 

Thanks for the help!

 

/Rasmus

Hi rasmussen81,

 

Has your issue to been solved totally right now? If you still encounter with this issue, could you please provide some fiddler trace for further text?

 

Regards,

Jimmy Tao

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors