Power BI connector, data set empty

(0) Share

Report

Posted on by Voltes

294

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.

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.

Thanks in advance.

Categories:

Using connectors

All responses (3)

Answers (1)

Sort by

ChristianAbata 8,953 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

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.
Verified answer

ChristianAbata 8,953 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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/