PowerBI Connection Write Data Error

Sidey1978

Hi all

I'm having some difficulty writing data to PowerBI.

I have a test sample dataset that I have attached.

This is the error message:

This is the configuration setup of the tool:

If I look in PowerBI I can see that the table has been created, but the data itself hasn't been populated... Is there anything obvious in the setup that I have missed?

Thanks

Jonathan

Test_Workflow_20230103.yxmd

Publish

Settings

Power BI

Accepted answers

Felipe_Ribeir0

Hi @Sidey1978

The error message is saying that the problem is with the Posting Date column. I suggest you to take a look at the column and data type inside your workflow and see if it match what the dataset that you are trying to populate inside power bi service is expecting.

Example:

The Posting Date is a date with 10 characters on Alteryx and on Power BI dataset?

Am i sending some strange character to Power BI dataset?

I saw that you are replacing nulls for blanks, try to keep them as nulls for Posting Date:

All comments

TheOC

hey @Sidey1978 ,

The error is suggesting you have a column header that is unexpected. Specifically this part:

I suspect this issue is caused by your Existing File Action setting 'Overwrite (Keep existing columns)'. I would recommend changing this setting to 'Overwrite (update columns)' to tell the tool that you are wanting to adjust the schema of the existing file. Another option would be to ensure that what you are outputting matches the schema exactly of the file contained within PowerBI. If this is a new/fresh file, you will still have to use the update columns option.