Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Trying out datamarts for first time. Looking pretty good. However, there is one feature that just doesn't seem to work at all, unless I'm doing something wrong. I tried creating a visual query, which worked great. There is a very prominant button that says "Open in Excel".
When I click on it, an Excel file is downloaded containing a Power Query connection using a Native Query to the datamart's SQL Server. But it is unable to run the query. Instead gives error that SQL Server not found or configured for remote connections.
Solved! Go to Solution.
Found the problem! Turns out it was because IT had all outbound calls to port 1433 blocked by firewall. Soon as they lifted it, it worked.
Found the problem! Turns out it was because IT had all outbound calls to port 1433 blocked by firewall. Soon as they lifted it, it worked.
Hi @mattcarter865 ,
Please refer to:Introduction to datamarts - Power BI | Microsoft Learn
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your response. I reveiwed the link you provided on introduction to datamarts, twice. There is no information, at all, related to the problem I reported.