Power BI Datamart - VARCHAR Length

[Vince21]

Hi,

I'm testing the Power BI DataMart feature, and I have a question regarding varchar lengths.

When connecting to my DataMart with SQL Server Management Studio, I can notice that all text columns have a NVARCHAR datatype, and a specific length. How is this length defined by Power BI ? Is it possible to specify our own value ?

I noticed some "truncation" failure when trying to read data with SSIS from these DataMarts. I need to recreate the DataMart from scrach to be able to reset the length.

Kr,

Vincent

[Vince21]

Hello,

I would like to have some feedback on this please.

Can someone help ?

Vince

[GautierDumont]

Having the same issue. It is really annoying