Thank you for the video!! I've been noticing some issues with Scheduled Refresh and Web Sources, specially if you try to use another query as a building block of the web source call. There are very specific settings to make Scheduled Refresh available in this setup. Another weird thing is when you need to disable test connection because the base url doesn't return a 200 code.
@@CurbalEN One potential valuable additional topic is how to use this method with Dataflows in Power BI. I've just implemented API calls as Dataflow sources and one of the key benefits is it buffers other Power BI developers from the complexities of the query. I was able to copy the code from Power BI desktop to create the dataflows and it all worked; this is really neat. Now, I have Dataflows on scheduled refresh for multiple Power BI reports to use. One other feature I implemented in the queries is time delays between the calls to stop the API erroring.
thank you so much, i have been searching endlessly for a solution to auto refresh data from a web source. I read about options to have an SQL database, but I wanted to do it without one. This helped me a lot
Excellent tutorial. i needed to automate a refresh on an API as this method worked perfectly. I would never have figured this out without these instructions.
You are the best.. I’ve been looking for a comprehensive tutorial to help me with this issue and your videos have always been amazing. Thank you so much!!!
@@CurbalEN In the case where a query parameter has more than 1 value for example, mail?mailbox=inbox, return_fields =statusid,docinfo,attributes, search_type=PAGED, how would this work?
I have one of custom API which I have able to access in power BI Desktop which required access token authenticate but not able to refresh schedule in power bi serrvice it ask for Credential data source
Everything works for me on Power BI Desktop and Reports Server, but I can't get refresh to work on workspace - Credentials error, and Data source credentials are greyed out. I've waited for the longest time, they don't become active. Any idea how to fix this?
Thanks for the video I am trying to get the list of SharePoint site files and the site link I am getting from one SharePoint list first, but still getting that "dynamic content" error although I am using web.content to get site url from the list
I'm running into an issue with calling usda data. One of the query parameter includes spaces. If I typed the query direct into browser with spaces, it works. When using web.contents the spaces are escaped it seems, and the escape characters become part of the url. In doing so, the api call doesn't work. Any ideas?
Using this method, I tried to connect to Jira and was able to schedule refresh. But it fails and throws error "too many requests" on service. However, I am able to refresh from within pbix successfully.
I have an issue with the time zone, since the first schedule refresh happens, the real hours change to UTC time, and my line charts start showing future time Can you please help me!
Hi. I have an issue related with the access token which I have to add on the header. And I am not able to get the credentials. So would I have to add something like... Headers = [ access_token="123133123", content-type="application/json"}] after the Query ?
Hi. I’m fetching data via a python api which I made from polarion (gives a json response). I made a report and refreshed it on power bi desktop. It is working fine and the changes (if any are made within polarion) are getting reflected in the report. However, once I publish my report to power bi service and click on refresh, it is showing me the following error: Processing error: Unable to connect to the remote sever Why is this happening? I also have my API running and no sorts of credentials are applied. I even tried asking on the Power BI community, but didn’t get any help yet. Your insights would be appreciated. Thanks.
Thank you for the video!! I followed you to solve scheduled refresh but I stuck. Could you please help me? An error occurred in the ‘’ query. DataFormat.Error: We found an unexpected character in the JSON input. Details: Value=< Position=0
Thanks a lot, but i am still having problems, in my case i require to put a token authorization, how can i make it work on power bi online? Thanks in advance . Love your channel
I have a somewhat similar and weird situation. What happened was that my data used to be from SQL server which had to use a gateway to refresh. Then recently came the migration to Dynamics 365 (which didn't need any gateway). But to my horror, somehow I cannot "turn off the gateway" as the Power BI service insist I need to use the gateway even though I was sure there are nothing that links to the SQL server. Then I realised there are some Excel data sources which I unlinked and I was then able to configure the refresh. What's even more weird was that I link back the Excel sources the Power BI using D365 data sources, re-published and it was still fine (no insistence of using the gateway as well). Any possible explanations to this? But in any case, hope this is useful to anyone out there with the same situation as me.
Hi there, I still can't figure out how to change my parts in the m query, I do have a little other url. let Source = Json.Document(Web.Contents("xxxxxxx/tas/api/operators?page_size=100&start="&Number.ToText(start)), xxxxx) in Source How do I need to transform this part cause i dont have the last json part you use! Hope you can help me out!
Thank you for the video!!
I've been noticing some issues with Scheduled Refresh and Web Sources, specially if you try to use another query as a building block of the web source call. There are very specific settings to make Scheduled Refresh available in this setup.
Another weird thing is when you need to disable test connection because the base url doesn't return a 200 code.
Yes, forgot to mention that, thanks!
@@CurbalEN One potential valuable additional topic is how to use this method with Dataflows in Power BI. I've just implemented API calls as Dataflow sources and one of the key benefits is it buffers other Power BI developers from the complexities of the query. I was able to copy the code from Power BI desktop to create the dataflows and it all worked; this is really neat. Now, I have Dataflows on scheduled refresh for multiple Power BI reports to use. One other feature I implemented in the queries is time delays between the calls to stop the API erroring.
Well done :)
thank you so much, i have been searching endlessly for a solution to auto refresh data from a web source. I read about options to have an SQL database, but I wanted to do it without one. This helped me a lot
Excellent tutorial. i needed to automate a refresh on an API as this method worked perfectly. I would never have figured this out without these instructions.
Short and crisp video. Excellent.
Thanks!
Great video! I struggled with this for hours before, much appreciated!!!
Me too!! Took me forever to figure it out!
Thanks for the video, I help me so much!! I was looking for the solution two days :)
You are awesome. It worked like a charm. You are a great tutor.
You are the best.. I’ve been looking for a comprehensive tutorial to help me with this issue and your videos have always been amazing. Thank you so much!!!
And thanks you for the feedback :)
Any links to the same process for an odata feed? Having the exact same issue.
How would I break down a sharepoint url using this method? Please guide.
Could you please, help me? I followed the steps but my error still persists.
Awesome.. I was struggling with this error. Thank you very much.
Thanks. web.contents have relativepath. How to schedule refresh in case of odata.feed?
are you able to resolve with odata.feed ?
Do we need to do it for all the API calls made dynamically?
Yea
@@CurbalEN In the case where a query parameter has more than 1 value for example, mail?mailbox=inbox, return_fields =statusid,docinfo,attributes, search_type=PAGED, how would this work?
I have one of custom API which I have able to access in power BI Desktop which required access token authenticate but not able to refresh schedule in power bi serrvice it ask for Credential data source
Everything works for me on Power BI Desktop and Reports Server, but I can't get refresh to work on workspace - Credentials error, and Data source credentials are greyed out. I've waited for the longest time, they don't become active. Any idea how to fix this?
Thanks for the video
I am trying to get the list of SharePoint site files and the site link I am getting from one SharePoint list first, but still getting that "dynamic content" error although I am using web.content to get site url from the list
When I do this it works welll, but now it is asking for a Gateway, do we need to install a gateway for this to work properly?
Yes, web.Contents requires a PERSONAL gateway :(
I'm running into an issue with calling usda data.
One of the query parameter includes spaces. If I typed the query direct into browser with spaces, it works.
When using web.contents the spaces are escaped it seems, and the escape characters become part of the url.
In doing so, the api call doesn't work.
Any ideas?
There are different ways to escape the spaces, check the docs to see how they want it done
Thanks in a million. Great content. Awesome. Grade: A++💥
Love this channel!
Thanks!
Using this method, I tried to connect to Jira and was able to schedule refresh. But it fails and throws error "too many requests" on service. However, I am able to refresh from within pbix successfully.
I have an issue with the time zone, since the first schedule refresh happens, the real hours change to UTC time, and my line charts start showing future time
Can you please help me!
Hi. I have an issue related with the access token which I have to add on the header. And I am not able to get the credentials. So would I have to add something like... Headers = [ access_token="123133123", content-type="application/json"}] after the Query ?
Great, thanks. And how can we add headers there. I am getting an error which says "we cannot convert a value of type to binary to type list"..?
Hi. I’m fetching data via a python api which I made from polarion (gives a json response). I made a report and refreshed it on power bi desktop. It is working fine and the changes (if any are made within polarion) are getting reflected in the report.
However, once I publish my report to power bi service and click on refresh, it is showing me the following error:
Processing error: Unable to connect to the remote sever
Why is this happening? I also have my API running and no sorts of credentials are applied. I even tried asking on the Power BI community, but didn’t get any help yet.
Your insights would be appreciated. Thanks.
Genius!!!, thank you a lot!
can you show us how it is done from google sheets...please
Can you share pbix file in the description please? I'm struggling with my code. Thank you in advance 🙂
Thanks a lot for the content! I've been looking for a solution and your video was the only that solved my problem!
Glad it helped!
Thank you, You help me a lot!
hi, could you help us with Source = Csv.Document? thank you. raffalele
Thank you for the video!! I followed you to solve scheduled refresh but I stuck.
Could you please help me?
An error occurred in the ‘’ query. DataFormat.Error: We found an unexpected character in the JSON input.
Details:
Value=<
Position=0
It probably means that your json is corrupt. Check it with a json validator.
Thanks a lot, but i am still having problems, in my case i require to put a token authorization, how can i make it work on power bi online? Thanks in advance . Love your channel
Thanks for the video! I have a question. Is it possible to schedule refresh when you are conect to folders? Like the data is in excels.
Yes :)
i still see the error
Excellent 🎉... thanks for sharing
I have a somewhat similar and weird situation.
What happened was that my data used to be from SQL server which had to use a gateway to refresh.
Then recently came the migration to Dynamics 365 (which didn't need any gateway).
But to my horror, somehow I cannot "turn off the gateway" as the Power BI service insist I need to use the gateway even though I was sure there are nothing that links to the SQL server.
Then I realised there are some Excel data sources which I unlinked and I was then able to configure the refresh.
What's even more weird was that I link back the Excel sources the Power BI using D365 data sources, re-published and it was still fine (no insistence of using the gateway as well).
Any possible explanations to this? But in any case, hope this is useful to anyone out there with the same situation as me.
Excel sources might be reason you needed the gateway?
Thanks, helped a lot!
Awesome, Thank you.
Music name please @1:42 awesome music inbetween
Will check tomorrow:)
Top!
🥳🥳
Hello Mam, thanks, and Please explain kobo data API to power bi How to refresh data automatically?
Muito bom👏🇧🇷
Hi there,
I still can't figure out how to change my parts in the m query, I do have a little other url.
let
Source = Json.Document(Web.Contents("xxxxxxx/tas/api/operators?page_size=100&start="&Number.ToText(start)), xxxxx)
in Source
How do I need to transform this part cause i dont have the last json part you use!
Hope you can help me out!