Split columns in data extraction using fixed width ???

[strikw]

Hello

I need to import a document and separate it into columns by a certain number of characters, you have to do this in the Split option, however I have to do one by one, have any way to do this for several different sizes?

Example: Split table in 2 characters, after what is left of the Splip table in the 5 character, then in 10, then in 20 ...

In the excell I know that has this function of separator by fixed limit, if someone knows how to do in BI help me.

Thank you.

[LivioLanzo · Accepted solution]

@strikw

This can be accomplished in Power Query. When using the Table.SplitColumn function, for the argument called 'splitter', you can pass this other function which accepts a list of lengths