Forum Discussion
Helper IIExternal shared data not updating
Hello marius1106 ,
I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.
If my response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.
Helper IIThanks for your answer! I evaluated the aspects you mentioned:
1) I created the notebook so when I schedule it, I thinks it takes my user
2) "cross-tenant data sharing permissions support scheduled access": Could you show me where I can find this permission in the Admin portal? I didn't find it.
3) Lakehouse-Delay: My LH is filled 4 hours before I copy the data from it. I think thats not the problem.
And how can I see detailed logs for my notebook? When I click on "view detail" in monitoring I can only see the duration or JobID.
Hi marius1106 ,
To fix your scheduled T-SQL notebook not pulling updated data, while manual runs work start by checking cross-tenant sharing permissions. In the Admin portal, under Tenant settings → Export and sharing settings, ensure "External data sharing (preview)" is enabled in your tenant and "Users can accept external data shares (preview)" is enabled in the customer’s tenant. Microsoft’s documentation on data sharing covers this setup.
For troubleshooting, enable detailed logging by connecting the notebook to Azure Log Analytics (Fabric Monday guide) or add custom PRINT statements in the notebook to track progress. To ensure the latest data is fetched before copying, force a refresh using SELECT * FROM [External_Lakehouse_Table] OPTION (LABEL = 'ForceRefresh');
If scheduled runs still fail, try re-authenticating the notebook to renew credentials. For further guidance, check Microsoft’s notebook monitoring docs.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi marius1106 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hello marius1106 ,
I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.
If my response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.