Forum Discussion
Connect with sharepoint table view
hi team, i m trying to connect with sharepoint, i am able to see the table but not able to indentify the view nor i am able to see the view in power bi, i dont know weather we can directly connect w...
Yes, Is is displaying all columns but it is not showing data in some columns (who needs to expand) though data is present in sharepoint
If you're seeing columns with data in sharepoint that are not showing in PQ, then it's probably a "lookup" column type in sharepoint. These columns are foreign keys to some other sharepoint table. Sharepoint's GUI covers over this and just shows you the value, but PQ points to only that one table.
You can expand these columns, causing PQ to query the other table. This is (or at least was) achingly slow because it caused a new query call for every line individually. Alterntively you can connect to the second table and merge it in yourself.