Forum Discussion

BeLikeWater's avatar
BeLikeWater
New Member
2 years ago

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, o...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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!

BeLikeWater's avatar
BeLikeWater
New Member
2 years ago

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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi BeLikeWater , have you got any reason or solution for this issue? If so, can you share it in community? Thank you~