cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Solution Sage
Solution Sage

Refresh failed due to gateway configuration issues.

HI ALL
I am failing to refresh a report with the following error:

2019-01-16 14_47_05-Clipboard.png

 

 

 

 

 

 

 

 

 

 

 

 

Refresh failed due to gateway configuration issues.
This dataset requires a properly configured gateway in order to refresh.If you're using personal mode, please make sure your gateway is online.If you're using enterprise mode, please make sure you've added the following data sources in the Gateway Management PortalMySql { server : "localhost" , database : "DB" } 
Please try again later or contact support. 
If you contact support, please provide these details. Activity ID: 67750544-d437-4c6a-9d5a-ed51d0efaede Request ID: 1b0a07e8-af32-3cb8-4b6d-571c7a56621a Correlation ID: 3c2ac6e9-96de-9495-e51a-512a8854e86c Time: Wed Jan 16 2019 14:51:02 GMT+1100 (AUS Eastern Daylight Time) Version: 13.0.7840.233 Cluster URI: https://wabi-australia-southeast-redirect.analysis.windows.net

 

I am using the same gateway and cluster with another report and it works fine.

2019-01-16 14_48_50-Clipboard.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

What am I missing?
How this should be fixed?

Cheers!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Sage
Solution Sage

Re: Refresh failed due to gateway configuration issues.

Update

The bottom line, Power BI is a buggy tool.

As mentioned in the previous post, removing the JOIN clause from the query solved the original issue.

 

I found other issues on the way. For example re-publishing a report will not reflect all changes. The workaround will be to delete the dataset from Power BI service and re-publish a fresh copy (not overwrite).

 

Hope someone will find this post helpful.

 

Cheers!

A

 

View solution in original post

6 REPLIES 6
Highlighted
Solution Sage
Solution Sage

Re: Refresh failed due to gateway configuration issues.

OK,
I got rid of the first error. I added the port number to the connection string.

Now I have these errors:


details.pngrefresh history.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Any idea?
Credentials are fine and I am able to see the data pulled from the DB.
MySQL DB with localhost connection.

 

Cheers!

Highlighted
Microsoft
Microsoft

Re: Refresh failed due to gateway configuration issues.

Hi @AClerk,

 

Apart from MySQL Database, is any other type of data source contained in current dataset? If so, you also need to add that data source to Data Gateway.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Solution Sage
Solution Sage

Re: Refresh failed due to gateway configuration issues.

Hi @v-yulgu-msft

No other data source in this specific dataset.

I do have other data set(s) that use the same gateway and same MySQL DB, and there are no issues there.

Thanks
A

Highlighted
Solution Sage
Solution Sage

Re: Refresh failed due to gateway configuration issues.

HI ALL,

These are my findings so far.

I simplified my query in the SQL statement.

At first, my query contained a JOIN between 3 tables. 

i.e.

select * from A INNER JOIN B INNER JOIN C
ON A.id = B.id and A.id = C.id

 

Now I have changed it to a simple query.

select * from A.

 

After the change the refresh works as expected.

 

The question is about the JOIN caluse. Isn't it allowed? It is NOT supported?

The work around will be, I believe, to upload each table in a seperate query and join them in the Power BI relationship module.

Need to test if this works, though.

 

Thanks!

Highlighted
Solution Sage
Solution Sage

Re: Refresh failed due to gateway configuration issues.

Update

The bottom line, Power BI is a buggy tool.

As mentioned in the previous post, removing the JOIN clause from the query solved the original issue.

 

I found other issues on the way. For example re-publishing a report will not reflect all changes. The workaround will be to delete the dataset from Power BI service and re-publish a fresh copy (not overwrite).

 

Hope someone will find this post helpful.

 

Cheers!

A

 

View solution in original post

Highlighted
Advocate II
Advocate II

Re: Refresh failed due to gateway configuration issues.

No way! This is too much of a hassle! I'd rather refresh it manually from my desktop and hit publish every time after that then. Thanks for informing.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors
Top Kudoed Authors