cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

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 Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 517 members 5,621 guests
Please welcome our newest community members: