Forum Discussion
The downloaded data is HTML, which isn't the expected type. The URL may be wrong ...
Hello !
I tried a new query and also opened a new powerbi desktop file and it would always return the same. It started returning the error on the desktop after I published to the service and tried to refresh from there. (no ideia why)
However, I found something. By setting the code with a cookie on the header it would return the json again but then on the service it still wouldn't refresh, but then I installed the gateway and from there I was able to refresh everything just fine.
Honesty not quite sure what was happening or the problem was but I am still looking at it trying to understand, but so far found a workaround that way.Thank you,
João
Hi,
I faced the same issue and fixed it by following the steps below.
1) Open Power Query Editor.
2) Go to the first step (Source) in the table. Press the settings icon near the word 'Source'.
3) If the link is incorrect, replace the old link with the new/correct one and enter credentials, if necessary.
4) If the link is correct, replace the credentials.
You don't have to recreate your table. Just need to change the link and/or credentials and everything will go back to place.
Thank you!
I tried that url with Json.Document(Web.Contents(... and it worked as expected. Not sure what you are seeing. If you create a new query, do you still see the error?
Pat
Hello !
I tried a new query and also opened a new powerbi desktop file and it would always return the same. It started returning the error on the desktop after I published to the service and tried to refresh from there. (no ideia why)
However, I found something. By setting the code with a cookie on the header it would return the json again but then on the service it still wouldn't refresh, but then I installed the gateway and from there I was able to refresh everything just fine.
Honesty not quite sure what was happening or the problem was but I am still looking at it trying to understand, but so far found a workaround that way.
Thank you,
João
Hi,
I faced the same issue and fixed it by following the steps below.
1) Open Power Query Editor.
2) Go to the first step (Source) in the table. Press the settings icon near the word 'Source'.
3) If the link is incorrect, replace the old link with the new/correct one and enter credentials, if necessary.
4) If the link is correct, replace the credentials.
You don't have to recreate your table. Just need to change the link and/or credentials and everything will go back to place.
Thank you!
Hi FormigoJoao ,
Glad to hear the issue is solved. You can accept the suitable reply as solution, that way, other community members could easily find the answer when they get same issues.
Best Regards,
Community Support Team _ Yingjie Li
