Parse error with Power Bi Output Tool

[bersocha]

Hi community.

I´m getting the following error using the Power Bi Output tool:

Error: Power BI Output (101): Bad request syntax or unsupported method. Error parsing request for dataset sobe_wowvirtualserver|ecb5079c-b7a2-4df6-88c8-d7f59da9979c: Error encountered by JSON parser when reading input data for column '<pi>Estimated Deployment Date</pi>': <pi>Unexpected character encountered while parsing value: 1. Path 'rows[0]['Estimated Deployment Date']', line 1, position 1188.</pi>

This is the concatenates I´m using for the dates:

Appreciate any help on this.

[jimgillespie]

I am having similar issues for Date format.  I have been reading about limitations, but any support on this would be greatly appreciated.  Next step is working with Dataverse to accomplish the mission of creating datasets for Power BI.

[BilliePaul]

Same error here. I had a TXT file as input that brough in the date as a V_String.  I then converted the date fields using the DateTime in the Alteryx Workflow.  When I try to output to PowerBI I get the JSON parse error

[BilliePaul]

I reformatted the date using the DateTimeFormat([Date Field],'MM/dd/yyyy') and it successfully loaded.  I found a blog post for PowerBI that says it matters what format your system setting is in when you load to powerBI. Not sure if that is accurate, but changing it to the MM/dd/yyyy fixed it and that matches my system setting.   

[Ossama59]

yeah I did the same as i read that the power bi api only accepts date format in ISO, but even after converting the date fields to ISO usign datetime tool in Alteryx it still won't accept the data! 
can someone help me with this if there is something wrong I'm doing 

the field after formatting 

and the error generated:
Error: Power BI Output (1): Bad request syntax or unsupported method. Error parsing request for dataset sobe_wowvirtualserver|3de57128-93d8-49ed-aa6d-93bab25b99ef: Error encountered by JSON parser when reading input data for column '<pi>Inspection Date- formatted</pi>': <pi>Unexpected character encountered while parsing value: 1. Path 'rows[0]['Inspection Date- formatted']', line 1, position 468.</pi>

I'm using the latest version of power bi output tool v3.3.1

[thais_teixeira]

Pessoal, estou com esse erro e já tentei varias coisas e não resolve, alguem já passou por isso 

Error: Saída do Power BI (173): Falha ao inserir dados em "table1" - None.

[kaushal_kharkwal]

To resolve the issue in alteryx you can use the datetime tool, the key thing you have to mind when changing the format and publishing to PowerBI if the date format is in (dd-mm-yyyy) format you need to use (mm-dd-yyyy) format and it will parse the date field correctly also you need to unselect the old date field before you pass the values to powerbi workspace.

Hope this helps.

Kaushal

[MikeBird]

Hi, 
I'm going to jump in here as I've been having this problem for a few days even though it looks like it's been around for a while.

I recently updated one of my workflows to the PowerBI tool v3.4 and since then I've had this problem. 
I've been told that the tool has a defect, which didn't help, but the Power platform has also been updated which could have made it worse. 

Being in the UK, our default date format is dd/MM/yyyy so uploading to PowerBI as a Date type was the problem. 

As mentioned above, the format must be MM/dd/yyyy but it does not matter the type.

I changed the format to MM/dd/yyyy and the Type to string and it uploaded with no errors. 

I also found out that format of MM-dd-yyyy also worked.