Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
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?
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 58 | |
| 56 | |
| 35 | |
| 18 | |
| 14 |