Forum Discussion
Dataverse column shows Null values after Column Security is removed.
Community SupportHi , DavidBrunaugh
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
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!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Aniya,
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.
I went ahead and walked through the process of creating a dataflow in the service and the same issue is present.
- v-yueyunzh-msft
Hi , DavidBrunaugh
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: https://powerbi.microsoft.com/en-us/support/
For how to create a support ticket, please refer to https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly