Forum Discussion
Excel linked to DataSet through PowerBI - Unable to Refresh
Good evening,
We have multiple excel files linked to our PowerBI dataset (which is connected to Microsoft Dynamics BC) and they recently stopped refreshing. We receive the below error messages after "Refreshing OLAP Cubes" fails:
"Either a connection cannot be made to the wabu-us-north-central-b-redirect.analysis.windows.net server, or Analysis Services is running on the computer specified"
"Excel was unable to get necessary information about this cube. The cube might have been reorganized or changed on the server. Contact the OLAP cube administrator and, if necessary, set up a new data source to connect to the cube."
I did create a new data source (Excel) linked to the dataset that worked initially, but after saving/closing the file, and then coming back in later, it experienced the same issue. Not sure what is the next step I should take but would appreciate any suggestions. Just as an FYI I'm more of an accountant than an IT resource so my technical knowledge on this is limited.
Thanks,
Brian M
2 Replies
Hi, andoverprop
Please refer to the following links in the hopes of helping you.
Olap connection problem with Excel 2007 (microsoft.com)
Troubleshoot connecting Excel to Power BI data - Power BI | Microsoft Learn
Excel 365 to OLAP Cube in SSAS - Microsoft Community Hub
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Charlotte, unfortunately none of the suggestions on those links have solved the issue. What would be your recommendation for solving this issue, should we create a PowerBI support ticket?
