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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Updating data for push dataset

Hi All, I need some guidance in understanding how to do this. I am completely new to Power BI and need to build a dashboard which refreshes every hour in a day. I built it and was made aware of certain restrictions in it and thus stumbled upon the real time dashboard built up in power bi.

 

I did set up a push dataset for the real time dashboard in service. Now my challenge over here is 

  • It would be my team who would be updating the data every interval and thus would need some form kind of structure to enter the data in real time dataset
  •  I can't use Microsoft forms to enter data into my dataset due to usage restrictions
  • If I eliminate the forms option, how do I get my team enter the live data for the dashboard.

Also, would like to know how do we actually push data into this dataset. I have the dataset up but not able to figure out a way to enter any data into it yet.

 

Can someone please help in this regards. Thanking in advance

6 REPLIES 6
V-lianl-msft
Community Support
Community Support

Hi @Anonymous ,

 

Refer to this:

https://sharegate.com/blog/using-power-bi-for-additional-sharepoint-reporting 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hey @Anonymous ,

 

maybe this article can help you to achieve what you want: https://flow.microsoft.com/en-us/blog/create-a-streaming-dataset-in-power-bi-using-microsoft-flow/

 

Power Automate is used to push data into a streaming dataset.

 

Maybe there will additional license costs to use Power Automate.

 

Regards,
Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
TomMartens
Super User
Super User

Hey @Anonymous ,

 

visualizing real-time data is not that easy.

 

Using a real-time dataset means you have to use the Power BI REST API to push data into that push dataset, this article outlines the available methods: https://docs.microsoft.com/en-us/rest/api/power-bi/pushdatasets.

 

From your description, I assume it's not about real-time.

 

For this consider using a database as datastore that supports directquery connection mode and then use "Automatic Page refresh".

From my understanding, this is sufficient for the use case you have described in your initial post.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Anonymous
Not applicable

From my understanding, the automatic data refresh would allow me to only schedule it 8 times a day. However I want it more frequently. 

 

Also, what if my team updates the data in the selected data source and none of them has a pro account. Then how would the refresh work in that case when I am not around? Does using on premises gateway solve this issue? 

 

I am sorry if my questions are confusing as I am not able to find ways to put up my project live

Hey @Anonymous ,

 

there are 2 types of how you can connect to data

  • importing data to a Power BI dataset
    data will be "copied" from the data source to the Power BI dataset
  • using directquery (https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about)
    just some metadata (tables and table structure) will be used to create the Power BI dataset. The data will not be "copied" to the Power BI dataset, for this reason, there is no need for data refresh. Whenever a user interacts with a report, current data will be used. Connecting to data using directquery does not come with any limits of data refresh, simply because there is no need for a data refresh.

Hopefully, this provides some additional insights.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Anonymous
Not applicable

@TomMartens Thanky you for pointing this out to me. I have gone throught the documentation and my challenge still remains as the data source that my team would be using to update the interval data is going to be an excel file on sharepoint and i don't see we can use the Excel file as a source for direct query. I am still stuck and not sure on how to proceed with my requirement.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.

Top Solution Authors
Top Kudoed Authors