Forum Discussion

Resolver III

9 years ago

Solved

ODATA need gateaway?

Hi, everybody

I have read I don't need gateaway if i get data from ODATA feed.

The only thing it's supposed I have to do is enter credentials in Power BI.

I have published Power BI desktop file where data comes from ODATA feed and credentials are disabled.

Am I doing something wrong?.

Thanks,

Angel
9 years ago
Hi, Anonymous

The problema was in my dataset.

I have optimized keys and it works,

Thanks, anyaway

13 Replies

Anonymous
Not applicable
9 years ago
Hi Angel,

Do you connect to OData feed of online service or on-premises service in Power BI Desktop? If you connect to OData feed of on-premises service, after you publish Power BI Desktop file to Service, gateway is required when you refresh the dataset.

In addition, which authentication method do you choose when connecting to OData feed in Power BI Desktop? And could you please post the screenshot of your data sources in Power BI Desktop? You can go to File -> Options and settings ->Data source settings to check data sources.

Thanks,
Lydia Zhang
- Angel
  Resolver III
  9 years ago
  Hi, Anonymous
  
  ODATA feed is generated by Microsoft Dynamics NAV.
  
  I use basic authentication.
  
  Many thanks,
  - Anonymous
    Not applicable
    9 years ago
    Hi Angel,
    
    Please install on-premises gateway and add the OData data source under the registered gateway, then check if you are able to schedule refresh for your dataset.
    
    Thanks,
    Lydia Zhang
- Anonymous
  Not applicable
  6 years ago
  Hi Lydia,
  We have on-premises report server, how can i schedule refresh my Power BI file which uses OData?
  I cant see any option on the PBIRS to select the gateway etc.