Forum Discussion

barakb32's avatar
barakb32
Advocate I
11 years ago

Refresh Project Online OData

Hello,

 

I am trying to refresh a report built on Project Online OData with the new Power BI.

I use Power BI Desktop to connect to the OData and generate a pbix file.

I go to my Power BI site and upload the file.

 

I go to the new dataset: when I click on Schedule Refresh - everything is grayed out. When I click on Refresh Now - I get a message that I need to set credentials to the datasource, which is impossible since the Manage Data Source section s grayed out.

 

Regards,

Barak

5 Replies

    • barakb32's avatar
      barakb32
      Advocate I

      Hi Eno1978,

       

      This is what I read on the link you attached:

       

      Online data sources


      A Power BI Personal Gateway is not required in order to refresh datasets that get data only from an online data source.

      REFRESH NOW and SCHEDULE REFRESH are supported without a Gateway for datasets uploaded from:

      • Microsoft Excel 2013 (or later) workbooks where Power Query or Power Pivot is used to connect to and query data from an online data source.
      • Microsoft Power BI Desktop files where Get Data is used to connect to and query data from an online data source

       

      OData is Online, so personal gateway is not required.

       

      Regards,

      Barak

  • Hi barakb32,

     

    it seems to me that Odata-Refresh in PBI is generally quite buggy at the moment.
    Have you created the Odata-Feed yourself and what kind of authentication is setup on the feed?

    I have tested quite a few combinations and the one thing that is sorta-kinda (sometimes) working right now is to setup basic-authentication on the server serving the Odata-Feeds. Mind you, after changing the server setup you'll have reupload the .pbix file with authentication enabled. 

    Grettings,
    Lukas 

  • Hi, 

    I am also have same issue, No Option to Refresh the data on Power BI Web. 

    Please help me is that some user rights issue or something other?