Updating data for push dataset

[Anonymous]

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

[V-lianl-msft]

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.

[TomMartens]

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

[TomMartens]

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

[Anonymous]

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

[TomMartens]

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

[Anonymous]

@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.