PBI Service: OData dataset Refresh issue - Needs personal Gateway configured ???

[LuisQuedas]

Hi All,

I created a Report using an OData Feed as a data Source using BPI Desktop, then I published it to the BPI Service, so far so good.

When I try to schedule the dataset refresh I have got the following information:

 "You data gateway (Power BI - Personal) is offline. To set refresh scheduling, make sure your gateway is online."

But taking into consideration the Power BI Documentation section: "Data refresh in Power BI", (https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-data/), it doesn't make any sense...

"Power BI Desktop file with data from an OData feed

In this case, you use Get Data in Power BI Desktop to connect to and import census data from an OData feed. You create several reports in Power BI Desktop, then name the file WACensus and save it on a share in your company. You then publish the file to the Power BI service.

In this case, you can manually refresh the data in the WACensus dataset or setup a refresh schedule. Because the data in the data source comes from an OData feed online, you do not need to install a gateway, but you will need to go into the WACensus dataset’s settings and sign in to the OData data source. You can then setup a refresh schedule so Power BI automatically connects to the OData feed and gets updated data. Your reports and dashboards will also be updated automatically."

BTW, the feed that I'm using has a URL like  https://ServerName.com/APIName/Data and uses Basic authentication.

Do you have any idea why this behavior happen?

Many Thanks, Luis

[v-shex-msft]

Hi @LuisQuedas,

As document said, you only need to config the  "Data Credentials" to connect the datasource, then turn on the schedule refresh.

>>BTW, the feed that I'm using has a URL like https://ServerName.com/APIName/Data and uses Basic authentication.

You need to ensure your credentials is use basic mode to connect.(you can modify this setting at:  Settings -> Datasets -> Data Source Credentials -> Edit credentials ->Authentication method)

Regards,

Xiaoxin Sheng

[falsuhail]

Suppose it's an open data Odata feed (namely this: http://rajapinnat.ymparisto.fi/api/vesla/2.0/), is the process still the same? I did change the authentication method settings to basic (though it feels silly, since it's open data...), but PowerBI still won't provide the option for scheduled refresh.

Regards,
Faris