Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
This just stopped working last week. I have had a power bi datamart set up in my Premium Capacity workspace for the better half of one year and it has been working great. I have been using the SQL Connector string to tap into this datamart with tools like SSMS, Excel, power bi, etc.... However just last week I noticed that this connection is no longer working and am getting the following error. Below is a view of the error I get both in excel and SSMS. Why is this no longer working and how do I get this working again??
I did notice that my server named changed from having the "datamart.pbidedicated.windows.net" at the end to now having "datamart.fabric.microsoft.com".... but this wasn't something I did to change and not sure if this was the cause bacause I know other people at other companies that have the "datamart.fabric.microsoft.com" in their connection strings for datamarts and it is working just fine for them, so not sure if this is the reason why it broke...
**We do not have Fabric Capacity.... we only have Premium Capacity**
**Also I tried to create a completely new premium workspace and a brand new datamart with sample data loaded... tried the sql connection in SSMS and Excel.... same thing, doesn't work**
Below is the SQL Connection String to my datamart....
pkda6fq76qwehn3qjidyapsplm-45nucqcz24uunhp643uxaqorju.datamart.fabric.microsoft.com
Error from Excel view
Error from SSMS
Also this is not just effecting datamarts, but also anything else with SQL strings in Power BI like Warehouses or Lakehouses too.
How do I get this resolved, but also how did this break????
Thanks!
Solved! Go to Solution.
We have similar issues with our datamarts. Microsoft changed the enpoints without telling us and without
Since you have a Pro license you should open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Thanks I have reached out to MS Support and will let you all know what they say.
Hi @tbucki1 ,
May I ask if you have resolved this issue? If so, please let us know how that was resolved and mark the reply as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
No this is not resolved yet. I have connected with Microsoft Support and so far they have not been able to figure it out. They are still working on my ticket, but so far we have not been able to figure this out.
We have similar issues with our datamarts. Microsoft changed the enpoints without telling us and without
Since you have a Pro license you should open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
49 | |
28 | |
21 | |
20 | |
20 |
User | Count |
---|---|
52 | |
51 | |
26 | |
26 | |
22 |