cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Dataset and Table details when automating Power BI refresh for Excel on SharePoint Online Site.

Hi Community,

I was able to automate my Power BI Dataset and Reports successfully by following this link https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/. The moment my business user modifies/uploads a "Specific Named Excel.xlsx file into a folder (which only he/she has access to) on SharePoint Online Site, the corresponding Power BI Dataset and Report Refresh successfully. Thanks to Nikhil Gaekwad.

However, I am still curious as to why Power Automate has suggested to follow the below path (per screenshots), which is a hurdle that I couldnt' pass through.

What is the Dataset ID (I referred to this link https://www.cathrinewilhelmsen.net/2019/02/07/how-to-find-dataset-id-power-bi/, thanks to Cathrine Wilhelmsen) and Table name (I tried to use the table names from Power Query, again, there are more than 1 tables!) that should be populated in Power BI Dataset section in this Flow and why is Microsoft Power Automate having a step in the middle which asks me for OneDrive details whereas my Excel.xlsx file is on SharePonit Online...!!

2020-05-05_11-35-37.jpg2020-05-05_11-43-43.jpg2020-05-05_11-44-15.jpg2020-05-05_11-53-38.jpg

Did anyone got this thing working for you? Can you please share some screenshots so I know for sure!

Thanks in advance, C

3 REPLIES 3
Highlighted
Microsoft
Microsoft

Re: Dataset and Table details when automating Power BI refresh for Excel on SharePoint Online Site.

Hi giftedbrain,

 

Thank you for posting your question and detailed explanation!  I've asked a few of our resident experts to take a look and respond if they feel they can help resolve your problem!

 

Thank you for posting and have a great day!

 

Eric

Highlighted
Super User IV
Super User IV

Re: Dataset and Table details when automating Power BI refresh for Excel on SharePoint Online Site.

Hi @Anonymous ,

 

i assume that it only works with "Push dataset".

 

Real-time streaming in Power BI

https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website

Highlighted
Super User III
Super User III

Re: Dataset and Table details when automating Power BI refresh for Excel on SharePoint Online Site.

Hi @Anonymous,

 

as @mwegener thought, the Flow connector Add rows to a Power BI dataset can only be used with streaming datasets created in the service, as I used here in my post on using Forms, Flow and a Power BI Streaming dataset for example.

 

You can either use a Push dataset or a Streaming dataset, both from the documentation Marc already shared.

For that, you'll need to select the API dataset when creating a new streaming dataset in the service.

nickyvv_0-1593081069143.png

 

In the next screen, if you leave Historic data analysis to Off, you will have a streaming dataset. This will store your data into a temporary cache, which quickly expires

If you check it to On, it will be a push dataset, with the data being available until you clear the dataset.

image.png



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Blog: nickyvv.com | @NickyvV


Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors