cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
alle
Level: Powered On

add rows to a dataset power bi - Bad request

Trying to build a sentiment flow to create a dataset in power bi. When I test my flow everything works until the i get to the end in power bi. 

Error message : Error parsing request for dataset sobe_wowvirtualserver|5b66dc79-33b2-4bce-bbb1-04cebfea23c9: Conversion error on column '<pi>RetweetCount</pi>': <pi>Input string was not in a correct format.</pi>

 

I take this as "retweetcount" is sent in wrong format or power bi expect it in another format. 

However as i check the streaming flow in power bi it is set as a "number" (only text, number and date available as format choices) so it should not be a problem.

 

 

Later I found out that if I turn the "historical data analysis" switch off, then the flow will run without problems. 

 

But I would like to get historical data and I do not know how to fix that.

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: add rows to a dataset power bi - Bad request

Hi @alle,

 

Could you please share a screenshot of your flow's configuration?

 

When the "Historical data analysis" option is disabled, it would create a streaming dataset, if the "Historical data analysis" option is enabled, it would create a streaming dataset and a push dataset. The functionality of this option is equivalent to using the Power BI REST APIs to create a dataset with its defaultMode set to pushStreaming.

 

More details about the "Historical data analysis" option of a streaming dataset, please check the following article:

https://docs.microsoft.com/en-us/power-bi/service-real-time-streaming#using-power-bi-rest-apis-to-pu...

 

In addition, please check and see if the following article would help in your scenario:

https://powerbi.microsoft.com/en-us/blog/push-rows-to-a-power-bi-streaming-dataset-without-writing-a...

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
alle
Level: Powered On

Re: add rows to a dataset power bi - Bad request

Hi Kris, thank you for the links. They were informative.

 

I want to use the setting "historical data setting", and i couldn´t fix it yet.

 

Screenshots:

Flow error.PNGFlow PB error.PNG

The full error message = 

{
  "error": {
    "code""InvalidRequest",
    "message""Error parsing request for dataset sobe_wowvirtualserver|5b66dc79-33b2-4bce-bbb1-04cebfea23c9: Conversion error on column '<pi>Retweet Count</pi>': <pi>Input string was not in a correct format.</pi>"
  }
}

 

 

Power BI API settings:

Power BI apirsettings.PNG

 

The problem seems to be the column "Retweet count", dont understand why, since I set it as a number

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (6,118)