Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power Bi Limitation Confusion? Characters per value for string column in POST rows operation

I am currently building a Power Bi script within Powershell which imports a CSV and sends the data within this CSV into a dataset in Power Bi.

 

I am able to send data which is less than 4,000 characters long within the CSV into Power Bi.  However, once I exceed this limitation, I recieve an error message. 

 

Taking a look at the Power Bi Limitations and I found this:

4,000 characters per value for string column in POST rows operation

 

After looking into this limitation a bit further, I have found a post on Power Bi which talks about the support of 128k characters per value for string column in POST rows operation.  [Post:  https://powerbi.microsoft.com/hu-hu/blog/newdatasets/] 

 

I am looking for a way to work around this issue.  Whether it's enabling the 128k characters (which would be enough for my needs) or building a PowerShell loop which iterates through 4,000 characters at a time per POST operation then continues, my overall goal is to get the full CSV imported. 

 

Any ideas on how I could go about doing this? 

 

Thanks!

 

1 Reply

  • Out of curiosity have you figured out an explanation or solution for this?