How to refresh web sources in Power BI service

Подписаться 135 тыс.

Просмотров 27 тыс.

50% 1

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

Опубликовано:

22 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 60

@MegaVinoba 3 года назад

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 Месяц назад

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 :)

@Mateus-yq9uv Год назад

Could you please, help me? I followed the steps but my error still persists.

@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 :)

@waldof86 3 года назад

Great video! I struggled with this for hours before, much appreciated!!!

@CurbalEN 3 года назад

Me too!! Took me forever to figure it out!

@pranaysharma8694 2 года назад

Awesome.. I was struggling with this error. Thank you very much.

@vinodkotiya Год назад

You are awesome. It worked like a charm. You are a great tutor.

@johng5295 2 года назад

Thanks in a million. Great content. Awesome. Grade: A++💥

@johnbullivent858 Год назад

Any links to the same process for an odata feed? Having the exact same issue.

@arbazahmad7177 5 месяцев назад

Excellent 🎉... thanks for sharing

@RetainTheDark 2 года назад

How would I break down a sharepoint url using this method? Please guide.

@bart4375 6 месяцев назад

Thanks, helped a lot!

@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"..?

@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.

@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.

@AaronShegrud 2 года назад

Awesome, Thank you.

@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?

@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

@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!

@thantwinmya5985 3 года назад

Love this channel!

@CurbalEN 3 года назад

Thanks!

@DanielMoraisPRO 2 года назад

Thank you, You help me a lot!

@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

@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

@pauloricardoandrade8585 3 года назад

Muito bom👏🇧🇷

@veerendrasai1745 3 года назад

Thanks. web.contents have relativepath. How to schedule refresh in case of odata.feed?

@hamytube Год назад

are you able to resolve with odata.feed ?

@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?

@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 ?

@haribabudusi 3 года назад

Hello Mam, thanks, and Please explain kobo data API to power bi How to refresh data automatically?

@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

@Rhcpmusic297 Месяц назад

Do we need to do it for all the API calls made dynamically?

@CurbalEN Месяц назад

Yea

@Rhcpmusic297 26 дней назад

@@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?

@Rhcpmusic297 18 дней назад

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 18 дней назад

Yes, web.Contents requires a PERSONAL gateway :(

@ghnwgfghnb 2 месяца назад

i still see the error

@powerbinareal 3 года назад

Top!

@CurbalEN 3 года назад

🥳🥳

@fabioyoiti2683 10 месяцев назад

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!

@venkatv4993 3 года назад

Music name please @1:42 awesome music inbetween

@CurbalEN 3 года назад

Will check tomorrow:)

@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!