Forum Discussion
Error in Analyze in Excel - Connection String
Hi Anonymous
As far as I know, this issue should not be related to the Tenant Administration Portal.
Maybe 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 How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Thank you for your understanding.
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
Consider updating the Connection String in Power BI, open the Power BI Desktop file that was used to publish the report to the Power BI Service. Go to the "Transform Data" or "Get Data" > "Data Source Settings" to find the data source for the OLAP cube. Update the connection string to the correct one that points to the OLAP cube. After updating, republish the Power BI report to the Power BI Service.
Or you can create a template Excel file with the correct connection string to the OLAP cube. When you need to update the data, export the latest figures from Power BI to CSV or Excel, and then import this data into your template Excel file.
Save a workbook as a template - Microsoft Support
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.
Do you know if there's something that can be done from the tenant administration portal?
Hi Anonymous
As far as I know, this issue should not be related to the Tenant Administration Portal.
Maybe 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 How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Thank you for your understanding.
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.