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, 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

  • Anonymous's avatar
    Anonymous
    Not 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!

    • BeLikeWater's avatar
      BeLikeWater
      New 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!

      • Anonymous's avatar
        Anonymous
        Not applicable

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