Parse error with Power Bi Output Tool

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:

Alteryx Error.JPG

Appreciate any help on this.

Error Message

Accepted answers

All comments

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.

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

Date.png

Before Publishing to PowerBI.png

powerbi-date-parse.yxmd

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.

Screenshot 2024-08-13 080654.png

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.

bcawells

@MikeBird were you able to get the data type to be recognised as a DateTime value in PowerBI as a PowerBI dataset?

My issue is that the Data Category is still unrecognised and you cannot connect to Power Query to change this as it is a PowerBI dataset

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235