Forum Discussion
Sql Analysis olap datacube connection failed
Hi JannesL05 ,
As the troubleshooting steps did not resolve your issue, could you please raise a Microsoft support ticket for further investigation? You can create a Microsoft support ticket using the link below.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Thank you!!
Hi v-sathmakuri thanks for your help!
I'am using SQL 2022 and I have four different cubes. One of them works with the live connection, but the other three give me the error. Changing the language didn't help, unfortunately.
Community SupportHi JannesL05 ,
Compare the configurations of the working cube with the non-working cubes to identify any differences. Double check if there are any security or role based restrictions on the non working cubes that might be preventing Power BI from accessing the metadata.
Please check whether you have access to the other cubes. If you have access, reprocess the non-working cubes in SSMS to ensure no processing errors exist.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!
- v-sathmakuri
Hi JannesL05 ,
May I ask if the provided solution helped in resolving the issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have
similar problems to solve it faster.
Thank you!!
Hi v-sathmakuri Unfortunately, the problem hasn't been resolved yet. I have all the rights, and in Excel, for example, I can connect the cubes. In Power BI, too, however, there are problems with the live connection.
- v-sathmakuri
Hi JannesL05 ,
As the troubleshooting steps did not resolve your issue, could you please raise a Microsoft support ticket for further investigation? You can create a Microsoft support ticket using the link below.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Thank you!!