Forum Discussion
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
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!
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.