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
3 жыл бұрын
Yes, forgot to mention that, thanks!
@graemegourlay2850
3 жыл бұрын
@@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.
@CurbalEN
3 жыл бұрын
Well done :)
@fabioverhorstert7885
3 ай бұрын
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
@graemegourlay2850
3 жыл бұрын
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.
@hi_vishy
3 жыл бұрын
Short and crisp video. Excellent.
@CurbalEN
3 жыл бұрын
Thanks!
@johnnyluisriverabarzola8266
Жыл бұрын
Thanks for the video, I help me so much!! I was looking for the solution two days :)
@waldof86
3 жыл бұрын
Great video! I struggled with this for hours before, much appreciated!!!
@CurbalEN
3 жыл бұрын
Me too!! Took me forever to figure it out!
@vinodkotiya
Жыл бұрын
You are awesome. It worked like a charm. You are a great tutor.
@cesarchicaiza4831
3 жыл бұрын
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
3 жыл бұрын
And thanks you for the feedback :)
@Mateus-yq9uv
Жыл бұрын
Could you please, help me? I followed the steps but my error still persists.
@pranaysharma8694
2 жыл бұрын
Awesome.. I was struggling with this error. Thank you very much.
@niltonguerra9077
2 жыл бұрын
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
@johnbullivent858
Жыл бұрын
Any links to the same process for an odata feed? Having the exact same issue.
@johng5295
3 жыл бұрын
Thanks in a million. Great content. Awesome. Grade: A++💥
@victorcf9152
2 жыл бұрын
Genius!!!, thank you a lot!
@hi_vishy
3 жыл бұрын
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.
@thantwinmya5985
3 жыл бұрын
Love this channel!
@CurbalEN
3 жыл бұрын
Thanks!
@arbazahmad7177
7 ай бұрын
Excellent 🎉... thanks for sharing
@DanielMoraisPRO
3 жыл бұрын
Thank you, You help me a lot!
@AaronShegrud
2 жыл бұрын
Awesome, Thank you.
@RetainTheDark
2 жыл бұрын
How would I break down a sharepoint url using this method? Please guide.
@tayfuny3441
2 жыл бұрын
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"..?
@arty4NR
2 жыл бұрын
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?
@bart4375
8 ай бұрын
Thanks, helped a lot!
@kedar09
2 жыл бұрын
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.
@veerendrasai1745
3 жыл бұрын
Thanks. web.contents have relativepath. How to schedule refresh in case of odata.feed?
@hamytube
2 жыл бұрын
are you able to resolve with odata.feed ?
@romariodejesusariaszuniga6558
2 жыл бұрын
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!
@Rhcpmusic297
2 ай бұрын
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?
@CurbalEN
2 ай бұрын
Yes, web.Contents requires a PERSONAL gateway :(
@Justbrowsingsoflo
Жыл бұрын
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?
@CurbalEN
Жыл бұрын
There are different ways to escape the spaces, check the docs to see how they want it done
@gayatrilshinde1560
Жыл бұрын
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
@haribabudusi
3 жыл бұрын
Hello Mam, thanks, and Please explain kobo data API to power bi How to refresh data automatically?
@non-dualist
Жыл бұрын
Can you share pbix file in the description please? I'm struggling with my code. Thank you in advance 🙂
@raffaelenazzaro8798
2 жыл бұрын
hi, could you help us with Source = Csv.Document? thank you. raffalele
@andreavelardesaldana5298
3 жыл бұрын
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.
@CurbalEN
3 жыл бұрын
Yes :)
@clifordakoyo406
Жыл бұрын
can you show us how it is done from google sheets...please
@powerbinareal
3 жыл бұрын
Top!
@CurbalEN
3 жыл бұрын
🥳🥳
@Rhcpmusic297
3 ай бұрын
Do we need to do it for all the API calls made dynamically?
@CurbalEN
3 ай бұрын
Yea
@Rhcpmusic297
2 ай бұрын
@@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?
@kahhengyeong7947
3 жыл бұрын
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.
@CurbalEN
3 жыл бұрын
Excel sources might be reason you needed the gateway?
@ghnwgfghnb
4 ай бұрын
i still see the error
@fabioyoiti2683
Жыл бұрын
Thanks a lot for the content! I've been looking for a solution and your video was the only that solved my problem!
@CurbalEN
Жыл бұрын
Glad it helped!
@pauloricardoandrade8585
3 жыл бұрын
Muito bom👏🇧🇷
@venkatv4993
3 жыл бұрын
Music name please @1:42 awesome music inbetween
@CurbalEN
3 жыл бұрын
Will check tomorrow:)
@MagoDigitalYT
2 жыл бұрын
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 ?
@TiesKuipers
2 жыл бұрын
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!
Пікірлер: 60