How to refresh web sources in Power BI service
If you have connected to a web source in power bi desktop and they try to connect to the service, you have probably gotten this error:
"You can't schedule refresh for this dataset because the following data sources currently don't support refresh: Data source for Query1"
In today's video I am going to show you what you need to do so your web source will refresh on Power BI Service.
Google maps API:
• #34 Calculate the dist...
Privacy levels:
• Power Bi / Power Query...
Chris Webb blog:
blog.crossjoin.co.uk/2016/08/...
Covid vaccines tutorial:
• COVID Vaccine Tracker ...
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
curbal.com/product/sponsor-me
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE
Пікірлер: 60
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 :)
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.
@CurbalEN
3 жыл бұрын
Thanks!
Great video! I struggled with this for hours before, much appreciated!!!
@CurbalEN
3 жыл бұрын
Me too!! Took me forever to figure it out!
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 :)
You are awesome. It worked like a charm. You are a great tutor.
Thanks for the video, I help me so much!! I was looking for the solution two days :)
Awesome.. I was struggling with this error. Thank you very much.
Thanks in a million. Great content. Awesome. Grade: A++💥
Thank you, You help me a lot!
Love this channel!
@CurbalEN
3 жыл бұрын
Thanks!
Genius!!!, thank you a lot!
Awesome, Thank you.
Thanks, helped a lot!
Excellent 🎉... thanks for sharing
Could you please, help me? I followed the steps but my error still persists.
Muito bom👏🇧🇷
Any links to the same process for an odata feed? Having the exact same issue.
Top!
@CurbalEN
3 жыл бұрын
🥳🥳
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
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"..?
How would I break down a sharepoint url using this method? Please guide.
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
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.
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.
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 have a question. Is it possible to schedule refresh when you are conect to folders? Like the data is in excels.
@CurbalEN
3 жыл бұрын
Yes :)
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!
Hello Mam, thanks, and Please explain kobo data API to power bi How to refresh data automatically?
Thanks a lot for the content! I've been looking for a solution and your video was the only that solved my problem!
@CurbalEN
10 ай бұрын
Glad it helped!
Thanks. web.contents have relativepath. How to schedule refresh in case of odata.feed?
@hamytube
Жыл бұрын
are you able to resolve with odata.feed ?
Can you share pbix file in the description please? I'm struggling with my code. Thank you in advance 🙂
hi, could you help us with Source = Csv.Document? thank you. raffalele
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?
can you show us how it is done from google sheets...please
Do we need to do it for all the API calls made dynamically?
@CurbalEN
Ай бұрын
Yea
@Rhcpmusic297
19 күн бұрын
@@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?
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
11 күн бұрын
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?
@CurbalEN
Жыл бұрын
There are different ways to escape the spaces, check the docs to see how they want it done
i still see the error
Music name please @1:42 awesome music inbetween
@CurbalEN
3 жыл бұрын
Will check tomorrow:)
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 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!