Not sure if this will help everyone, but I received this error because I had not yet given permissions to the SQL account for the new database I was trying to connect to. Make sure the account you're using has at least read permissions, otherwise this error will be thrown.
I had same issue and with your trick I manged to fix it.
However, in the next steps of the query i got the following message:
Know how to fix this?
Thx in advance.
The query itself contains a lot of metadata related to the source you are pulling from and it seems that this can get a bit out of whack. The case you are looking at here you have a many different steps you are going through. The issues for this error have typically been in the source step. To see all the steps and see how the query progresses you can take a look at the progression as each step generates a result which is operated agaist by the next step. The original trick to refresh the query, has worked for me and I was glad to see that it seemed to work with Power Query as well as it uses basically the same mechanism. If you do continue to get an error even after refresh, take a look at the advanced editor and see if something jumps out as not being in sync with your source in one of the later steps.
Hope this helps.
It might be resolved but if anyone had this problem with googla Anyltics API.
I found that the solution is to add a custom column and transform the query into a normal table. Otherwise power bi service, in my case, will no identify the correct table.
I am using power bi that has a dataset of multiple excel spreadsheets (tables) on sharepoint. I had no problems with refresh until....I had to add an additional table to the power query. I have two issues here...(1. how to fix the refresh 2. how to prevent this from happening as the dataset changes).
1. I get this error and I have followed the steps to resolve. When I use the desktop app, I hit refresh and everything works fine. It updates without error. When I go to "edit query" to see if there are errors, there are no errors. All I am going off of is the email I get that says the refresh failed. How can I narrow it down if there aren't errors? Is this error occurring for a specific table that I can isolate?
2. What caused this=> I added a table and created a power query in excel. When I appended the query to my existing query, what it does is creates a new tab with it appended. The only problem is that I have the dataset source pointing to the table "master" and now I have a table that is called "appended1". I have other tabs pointing to a tab called master and now I need to change the reference to appended1. It seems like I did something wrong with power query, so I went back through that process and tried other options when appending and still got the same result. I see myself having to fix this everytime a new tab is created. How can be more effective with this process?