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.
hi everyone
I have sharepoint online list imported successfully to PowerBI desktop.
When I am trying to expand below highlighted SecurityResource_test column, there are no columns to display and running into error when I click on Table.
Dont know why this specific column is showing red.
Solved! Go to Solution.
I ended up resolving the issue by joning Security ID column with user reference table.
The SecurityResource_test column shown above was not configured properly and is actually deprecated.
Hi Anonymous,
I met exactly the same issue for one list whether other lists in the same SP site works perfectly. After two days I've found a workaround by
1) graphical user interface : Get Data -> SharePoint Online list -> select option "Implementation 2.0" before entered your Site URL -> OK.
2) power query : = SharePoint.Tables("YOUR_SITE_URL", [Implementation="2.0", ViewMode="Default"])
Hope it will help 😉
Hi, @Anonymous
Thank you for sharing😀. Could you please mark your post as Answered since it is working now? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.
I ended up resolving the issue by joning Security ID column with user reference table.
The SecurityResource_test column shown above was not configured properly and is actually deprecated.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |