Skip to main content
Community site session details

Community site session details

Session Id : 0N00yJndrIlqXHmgzpOAyL
Power Automate - Using Connectors
Answered

Power BI connector, data set empty

Like (0) ShareShare
ReportReport
Posted on 8 Aug 2020 16:57:48 by 265

Hi, 

I'm trying to build Flow by using Power BI Connector. There is one feature called : Add row to dataset.

 

After choose it, and sign in (with the correct and same user account), obviously it is asking me Power BI Workspace. The selection are already correct as my current existing Workspace in Power BI.com, but strangely, the data set is empty.

Voltes_2-1596905750347.png

 

I do have data set, as I already have report over there. I wondering why there is no selection in Flow ? And if I type manually, it will not recognise.

Voltes_3-1596905837176.png

 

 

Thanks in advance.

  • Verified answer
    ChristianAbata Profile Picture
    8,949 Most Valuable Professional on 10 Aug 2020 at 00:03:46
    Re: Power BI connector, data set empty

    ohh @Voltes  well, you can't not add rows to a data set like sql server or other data source, the action add row to data ser is just to add data to a streming data set, as real time data set.

     

    See the next example friend

     

    https://powerbi.microsoft.com/fr-fr/blog/push-rows-to-a-power-bi-streaming-dataset-without-writing-any-code-using-microsoft-flow/

  • Voltes Profile Picture
    265 on 09 Aug 2020 at 15:46:49
    Re: Power BI connector, data set empty

    Hi Christian,

     

    The dataset is created from Power BI Desktop, and it has 2 sources, one is Azure SQL as it is from Dynamics 365 F&O and the other one is Excel from Onedrive.

     

    But I did try again by creating some table in CDS, add this new data source to my report, still when I connected again in Flow, the Data set selection is empty. I tried many time to delete the action and add but to no avail.

     

    Thanks.

  • ChristianAbata Profile Picture
    8,949 Most Valuable Professional on 09 Aug 2020 at 15:33:49
    Re: Power BI connector, data set empty

    hi @Voltes  what type of data set do you have? I mean it's an sql, is sharepoint?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Featured topics

Loading complete