Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All
I have a problem with my dataflow, it was working fine until yesterday and now it keeps failing.
I've created a connection using SharePoint.Files( "", [ApiVersion = 15] ) this was returning a table with all files within specific workspace.
PBI Desktop returned all the files and loads of nulls ( no idea what are the nulls in SP folders ) where the Dataflow only a few files ( records ) until the first null, so I could not see all the files past this point.
To solve the problem I have filtered out the nulls and this worked fine, it returned a list of all the files ignoring the nulls.
For some reason, as of yesterday this workaround does not work anymore and the dataflow version shows only the first few records ( as on the above picture ) and it does not get past null so I'm unable to see all the files in my SharePoint folder.
I've tried to change the ApiVersion to 14, which removes a problem of nulls in a table and lists all the file names and I have no problems if I wont to refer to a single file, however when I try to combine multiple files and I use Table.SelectRows() to select those, It adds an extra error row, and this row for some reason can not be removed.
Have there been any updates to Dataflows / PBI Service or Sharepoint Connector recently that could cause this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.