FieldValueAsText

[AngeloSacchetto]

Hello, I've recently tried run into an issue when using dataflows for my report that does not allow me to see all the necessary columns from an Online SharePoint List, I was trying to use the column expansion for FindValueAsText and it showed me the columns I wanted but the dataflow now times out at 2 hours. I assume that there are far too many files to use this method so I was wondering if anyone has some tips or tricks for maybe getting all the values from a SharePoint list without going through the field expansion step.

[v-yanjiang-msft]

Hi @AngeloSacchetto ,

By my test, expansion is the only way when connecting to SharePoint List. Or you can submit an idea in the idea forum to improve Power BI.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.