Datamart was not found error between two tenants

Hi ilhan_berberler 

Ensure that the datamart you're trying to access is correctly configured to be accessible from your global tenant. This includes verifying any cross-tenant data sharing settings and ensuring that your global tenant has the necessary permissions to access the datamart located in your local tenant.

Access shared semantic models in Power BI as a guest user from an external organization (preview) - Power BI | Microsoft Learn
Since the issue started occurring after a specific date, it's possible that there might have been changes to the credentials or the SQL connection string information. Double-check that the credentials used for the datamart in the global tenant are still valid and have not expired or been changed. Additionally, ensure that the connection string used in the report is correctly pointing to the datamart.
It's also important to review the tenant settings in both your local and global tenants to ensure that there are no restrictions or configurations that might be preventing the datamart from being found. This includes checking for any changes made around the date the issue started occurring.

Tenant settings index - Microsoft Fabric | Microsoft Learn

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Anonymous ,

Thank you very much for taking your valuable time to reply.

"Access Sharing Semantic Model" actually doesn't fit very well with the model I'm talking about. Because I am using Datamart on an external tenant, not a semantic model. Unfortunately, a similar setting on Datamart does not seem possible.

As you said, when I say "Copy SQL Connection String" on Datamart, I see that the SQL Connection String changes.

Old: <tenantid>-<datamartid>.datamart.pbidedicated.windows.net
New: <tenantid>-<datamartid>.datamart.fabric.microsoft.com

However, I can connect to both SQL Connection Strings in both Azure Data Studio and Power BI Desktop applications.

I published my model by editing a new SQL Connection String in my PBIX file. While working on Local Tenant, I still get the same error on Global Tenant.

I wanted to test the report on different tenants. I found a third tenant. (Consultant Tenant) I published my same PBIX file here and defined the necessary credentials on the service. Semantic Model is successfully refreshed on Consultant Tenant.

I compared the tenant settings of Consultant and Global via Admin Panel. I detected 2-3 differences and arranged them to be the same. But my problem still persists in Global Tenant.

Our client encountered the same issue with the datamart. It looks like the Microsoft error from the description. If you find a solution through your request, please share it with us. Thank you.