Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Naveen99K
Frequent Visitor

User ID, Username and Notebook not populated in Lakehouse Delta table history

 
11 REPLIES 11
Expiscornovus
Super User
Super User

Hi @Naveen99K,

 

Just to double check. Do you mean the User ID and userName columns have NULL values when you run the describe history command:

https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/delta-describe-history

 

%%sql

DESCRIBE HISTORY table_name

 

userid_username_null.png

 



Happy to help out 🙂

I share #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

@Expiscornovus , I am utilizing Pyspark code to import JSON data. Upon examining the table history, I noticed that the columns "User ID" and "userName" contain NULL values.

Anonymous
Not applicable

Hi @Naveen99K 
Thanks for using Fabric Community.
Can you please elaborate more on the issue? Please provide some screenshots and explain so that I can help you better.

Thanks.

Anonymous
Not applicable

Hi @Naveen99K 
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks

User ID and userName columns have NULL values when you run the describe history command:

Naveen99K_0-1713460363473.png

 

Anonymous
Not applicable

Hi @Naveen99K 
Thanks for your feedback. Apologies for the issue you have been facing. I tried to repro the scenario and faced the same issue at my side. Hence this is a bug. I have reported the same to our internal team. The team is working to fix the issue as soon as possible. 
I will keep you posted regarding the updates.
Appreciate your patience.

@Anonymous , I'm currently awaiting a resolution from your internal team to address the bug.

Anonymous
Not applicable

Hi @Naveen99K 
The team is working on the bug to fix it. I will let you know once it gets fixed.
Appreciate your patience.

Anonymous
Not applicable

Hi @Naveen99K 
We haven’t heard from you on the last response and was just checking back to see if you got some insights regarding the query. Otherwise, will respond back with the more details and we will try to help.
Thanks

Anonymous
Not applicable

Hi @Naveen99K 
We haven’t heard from you on the last response and was just checking back to see if you got some insights regarding the query. Otherwise, will respond back with the more details and we will try to help.
Thanks

Was this resolved? It's May 31st and I just tried checking on this information and was surprised it was still showing Nulls for everything. 

Pretty sure data was being stored there last year.

Helpful resources

Announcements
Fabric July 2025 Monthly Update Carousel

Fabric Monthly Update - July 2025

Check out the July 2025 Fabric update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.