Forum Discussion
Vince21
3 years agoNew Member
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
- GautierDumontNew Member
Having the same issue. It is really annoying
- Vince21New Member
Hello,
I would like to have some feedback on this please.
Can someone help ?
Vince