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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
Resident Rockstar
Resident Rockstar

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors