cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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
Highlighted
Community Support
Community Support

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.
Highlighted
New Member

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
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

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

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,674)