Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
arthurcruz
Frequent Visitor

WEB Data Source (CSV) refuses to refresh and asks for Personal Gateway (?)

Hello Guys!

 

To test this issue I prepared a really simple Dataset that contains only a small table (CSV) as a Web source (http).

Everything is fine on Power BI Desktop, but the Power BI Service is showing me the following error message if I try to Refresh it:

 

Error

 

 

This is very odd cause I don't have any data gateway set up... and the source is the WEB.

 

 

Do you guys need any other info?

Thank you in advance for the help!

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @arthurcruz

 

What the message is telling you is correct.

 

You need to install the Power BI Personal Gateway in order for your Web Source to refresh. This is a requirement in order for it to refresh.


Without a Gateway either Personal or On-Premise the data will not be able to be refreshed via the Power BI Service.

 

Here are more details if you wish to look into it: https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-data/#what-can-be-refreshed





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

4 REPLIES 4
GilbertQ
Super User
Super User

Hi @arthurcruz

 

What the message is telling you is correct.

 

You need to install the Power BI Personal Gateway in order for your Web Source to refresh. This is a requirement in order for it to refresh.


Without a Gateway either Personal or On-Premise the data will not be able to be refreshed via the Power BI Service.

 

Here are more details if you wish to look into it: https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-data/#what-can-be-refreshed





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi @GilbertQ!

Thanks for the link, as I use PowerBI for a very long time I didn't notice rules changing since November 2016 update:

 

Screen Shot 2017-10-11 at 01.53.59.jpg

 

As I've never installed this Gateway I'll do some experimentations tonight 😃

Thank you again for your help.

 

 

Hi @arthurcruz

 

Glad you found it useful and now can get it working and refreshing.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

After a very easy installation of the Gateway on our Server everything is working as expected Smiley Very Happy

 

This community is great.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors