Forum Discussion
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
- jili99New Member
Out of curiosity have you figured out an explanation or solution for this?