Forum Discussion
Dataverse: Certain columns loading only for some Power BI users but seemingly not a rights issue.
Hello all,
I'm importing tables in Power Query from Dataverse.
It works fine except for 1 column in 1 table.
We have 2 related columns: Statuscode & statuscodename.
When I load the table, only the statuscode loads. Statuscodename does not. I only get nulls:
When my colleague loads the table, both load:
I'm only doing the first 2 standard steps when loading data from Dataverse: Connect to the source & Navigate to the table.
I've tested & concluded the following:
- When my colleague loads the data, saves it & sends the file to me, I see the statuscodename. When I trigger a refresh, it disappears
- When I upload the semantic model to workspace and trigger a manual refresh, the statuscodename will not show
- Neither will it when a scheduled refresh is done
- I've tried opening only that table in a separate file, no succes.
- I was temporarely granted admin rights on the Dataverse, but that didn't help either.
- I have the same rights on the original data source (MS Project Operations) as my collegue for which it does work.
- I checked all Power Bi settings regarding loading, no succes.
- Normally, I have CreateNavigationProperties=false set in the source step in power query, but disabling that didn't help either.
I heard MS Project Operations saves data such as names related to codes (metadata I guess) in seperate tables which need to be joined in. But then how come my collegue does not need to load those metadata tables? We're using the same file.
If anyone has pointers, I'll be very grateful.
Kind regards
3 Replies
- AnonymousNot applicable
Hi BeLikeWater
I feel like this has something to do with some certain permission. I find that it is possible to set security for columns in Dataverse tables, maybe you can check if this column has this setting that causes the difference.
Configuring column level security in a Dataverse table (jondoesflow.com)
Also ensure that you have the same permission to the Dataverse table as your colleague. Check if your colleague may be in another group/security group that may have a higher permission to this table.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!- BeLikeWaterNew Member
Hello Jing,
Thanks for answering. I reconfirmed with the Dataverse & Project Operations admins, and I should have the necessary rights to view the columns
I also had a call with Power BI support, but that didn't lead to anything yet except scheduling another call with Power Apps support. Let's see 🙂
Kind regards!- AnonymousNot applicable
Hi BeLikeWater , have you got any reason or solution for this issue? If so, can you share it in community? Thank you~