Forum Discussion
Web.Page and Xml.Document available for cloud refresh without gateway?
Hi!
I am trying to figure out if using the M functions Web.Page() and Xml.Document() in a data model without a gateway configuration would give me the possibility of refreshing in in Power BI service.
I am reading a lot of blog posts about it and some people say that data imported with Xml.Document can be refreshed in Power BI service without gateway configuration (for example here: http://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-3-public-holidays ) but other people say it can't.
I can't try it for myself until march but I am creating a data model in Power BI desktop and would love to know the answer.
Thank you very much
Hi ContabilidadBI,
1. Web.Page() needs a Gateway to refresh. Please refer to this official document.
2. Xml.Document() can have functions like File.Contents or Web.Contents as parameter. Please refer to mt260907.aspx. So if it's File.Contents, how can it be refreshed without a Gateway? (Such as a local file). If it's Web.Contents, no Gateway needed.
Best Regards,
Dale
2 Replies
- v-jiascu-msftMicrosoft Employee
Hi ContabilidadBI,
1. Web.Page() needs a Gateway to refresh. Please refer to this official document.
2. Xml.Document() can have functions like File.Contents or Web.Contents as parameter. Please refer to mt260907.aspx. So if it's File.Contents, how can it be refreshed without a Gateway? (Such as a local file). If it's Web.Contents, no Gateway needed.
Best Regards,
Dale
- ContabilidadBIHelper III
Thanks Dale, yes its Web.Contents what I want to refresh without a Gateway.