Forum Discussion

Vince21's avatar
Vince21
New Member
3 years ago

Power BI Datamart - VARCHAR Length

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

2 Replies

  • Hello,

     

    I would like to have some feedback on this please.

     

    Can someone help ?

     

    Vince