cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
barakb32
Advocate I
Advocate I

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 5
jessicaf31
Helper I
Helper I

Same problem !!

siqbal
New Member

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?

 

MoorsTech
Advocate I
Advocate I

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 

hey Barakb32,

Have you downloaded the personal gateway? You need to do that before you will be able to set up refresh for your on-prem files.

 

https://support.powerbi.com/knowledgebase/articles/649846-power-bi-personal-gateway

 


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

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

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors