Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |