Dataverse column shows Null values after Column Security is removed.

Question

I recently removed Colum Security from a column in Dataverse. Ever since, the values from the column have shown null in Power Query even though they contain values in the source.

Source:

Power BI Model:

Is there anything I can do get these values to show up?

v-yueyunzh-msft · Answer

Hi ,&nbsp;DavidBrunaugh&nbsp;
Conveniently, you can expand this corresponding column field "jt_disgnosiscategoryname" to check and determine whether all fields of the column are null values, or are null values partially displayed?

In addition, you can confirm that this field "jt_disgnosiscategoryname" is the field "disgnosiscategoryname" in the corresponding data source, and you can expand all the fields to determine if there are similar fields at your convenience, because in my experience, the corresponding field names of Power BI may not necessarily display exactly the same name after successfully connecting to the data source.
Create a Power BI report using the Dataverse connector - Power Apps | Microsoft Learn
&nbsp;
If there is still a problem, you can try creating a dataflow on the service to connect to the same Dataverse data source to determine whether the field values can be displayed correctly in the dataflow, and if possible, we can consider using the newly created dataflow corresponding to the desktop connection to achieve the same data output as a work around.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!&nbsp;
&nbsp;
Best Regards,
Aniya Zhang
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly

davidbrunaugh · Answer

Aniya,&nbsp;&nbsp;Thank you for you respone and insight.I have checked the Column Quality and confirmed that the column is showing up 100% Null in Power Query.I also confirmed that the column in the data source is in fact the same column in my Power Query screenshots.&nbsp;I went ahead and walked through the process of creating a dataflow in the service and the same issue is present.&nbsp;

v-yueyunzh-msft · Answer

Hi ,&nbsp;DavidBrunaugh&nbsp;
Sorry for that it still not work , and i have no experience on the Dataverse.
But for your issue ,If you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.
The link of Power BI Support:&nbsp;https://powerbi.microsoft.com/en-us/support/
For how to create a support ticket, please refer to&nbsp;https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...
&nbsp;
Best Regards,
Aniya Zhang
If this post&nbsp;helps, then please consider&nbsp;Accept&nbsp;it as the solution&nbsp;to help the other members find it more quickly
&nbsp;