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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
AnandRanga
Helper III
Helper III

how to refresh data when i am using data feed ?

I am fetching the data in power BI from Dynamics 365 using Odata feed. I just want to know do I need to do some configuration for data refresh and how?

As I can't install data gateway for this. As this link says:

https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-data/

 

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.

 

How to do that?

Thanks 

1 ACCEPTED SOLUTION
v-ljerr-msft
Employee
Employee

Hi @AnandRanga,

I just want to know do I need to do some configuration for data refresh and how?

As I can't install data gateway for this. As this link says:



The link just says you do not need to install a gateway, which means you can still configure a gateway for it, but it is unnecessary.

 

In your scenario, you can just do as the link says:

1. Publish your pbix file to Power BI service.

2. Go to Power BI service -> Settings -> Datasets, select your dataset.

3. Sign in to Dynamics 365 by editing the Data Source Credentials.

4. Then you should be able to setup a refresh schedule for your dataset.

 

settings.PNG

 

Regards

View solution in original post

1 REPLY 1
v-ljerr-msft
Employee
Employee

Hi @AnandRanga,

I just want to know do I need to do some configuration for data refresh and how?

As I can't install data gateway for this. As this link says:



The link just says you do not need to install a gateway, which means you can still configure a gateway for it, but it is unnecessary.

 

In your scenario, you can just do as the link says:

1. Publish your pbix file to Power BI service.

2. Go to Power BI service -> Settings -> Datasets, select your dataset.

3. Sign in to Dynamics 365 by editing the Data Source Credentials.

4. Then you should be able to setup a refresh schedule for your dataset.

 

settings.PNG

 

Regards

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.