Forum Discussion
Switching PowerBI service data model connection in excel
- 1 year ago
Hi Rigensis,
After trying the every trouble shooting steps if still faces the same issue then please consider raising a support ticket for further assistance.
To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.
Thank you for being a part of Microsoft Fabric Community Forum! - 1 year ago
The solution for our company was that not only we were changing the tenant for PBI, but for the whole Microsoft ecosystem as well. And once a person's laptop was reprogrammed from company IT admins to work on the new tenant active directory by default, then the excel files also started working fine.
On one hand it makes sense, switching completely to the new tenant everywhere has solved the issue, but on the other hand a bit weird that by explicitly logging into excel with the new tenant did not entirely connect it to the PBI data from the new tenant. At the end of the day a full laptop user reboot and refactor to prompt login with the new tenant when starting up the machine was what solved the issue.
Hi Rigensis,
Could you please confirm if the issue has been resolved after raising a support case? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.
Thank you for your understanding and assistance.
Thank you.
The solution for our company was that not only we were changing the tenant for PBI, but for the whole Microsoft ecosystem as well. And once a person's laptop was reprogrammed from company IT admins to work on the new tenant active directory by default, then the excel files also started working fine.
On one hand it makes sense, switching completely to the new tenant everywhere has solved the issue, but on the other hand a bit weird that by explicitly logging into excel with the new tenant did not entirely connect it to the PBI data from the new tenant. At the end of the day a full laptop user reboot and refactor to prompt login with the new tenant when starting up the machine was what solved the issue.