Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Limitless Analytics with Azure Synapse

You're reading from   Limitless Analytics with Azure Synapse An end-to-end analytics service for data processing, management, and ingestion for BI and ML

Arrow left icon
Product type Paperback
Published in Jun 2021
Publisher Packt
ISBN-13 9781800205659
Length 392 pages
Edition 1st Edition
Languages
Tools
Arrow right icon
Authors (2):
Arrow left icon
Saranya Ravichander Saranya Ravichander
Author Profile Icon Saranya Ravichander
Saranya Ravichander
Prashant Kumar Mishra Prashant Kumar Mishra
Author Profile Icon Prashant Kumar Mishra
Prashant Kumar Mishra
Arrow right icon
View More author details
Toc

Table of Contents (20) Chapters Close

Preface 1. Section 1: The Basics and Key Concepts
2. Chapter 1: Introduction to Azure Synapse FREE CHAPTER 3. Chapter 2: Considerations for Your Compute Environment 4. Section 2: Data Ingestion and Orchestration
5. Chapter 3: Bringing Your Data to Azure Synapse 6. Chapter 4: Using Synapse Pipelines to Orchestrate Your Data 7. Chapter 5: Using Synapse Link with Azure Cosmos DB 8. Section 3: Azure Synapse for Data Scientists and Business Analysts
9. Chapter 6: Working with T-SQL in Azure Synapse 10. Chapter 7: Working with R, Python, Scala, .NET, and Spark SQL in Azure Synapse 11. Chapter 8: Integrating a Power BI Workspace with Azure Synapse 12. Chapter 9: Perform Real-Time Analytics on Streaming Data 13. Chapter 10: Generate Powerful Insights on Azure Synapse Using Azure ML 14. Section 4: Best Practices
15. Chapter 11: Performing Backup and Restore in Azure Synapse Analytics 16. Chapter 12: Securing Data on Azure Synapse 17. Chapter 13: Managing and Monitoring Synapse Workloads 18. Chapter 14: Coding Best Practices 19. Other Books You May Enjoy

Connecting Azure Synapse data to Power BI Desktop

Before we proceed further on this topic, it is important to understand what the different end points in the Synapse workspace are. When you go to your Synapse workspace within the Azure portal, you can see all the details pertaining to the workspace in the Overview section of the Synapse workspace.

In this section, we will learn about all the endpoints related to the Synapse workspace, as seen in the following screenshot:

Figure 8.17 – A screenshot of the Synapse workspace in the Azure portal highlighting different endpoints

Figure 8.17 – A screenshot of the Synapse workspace in the Azure portal highlighting different endpoints

To ensure that you are able to navigate the workspace without limitations and that functionality is not limited, ensure that the following URLs are accessible on port 80 and 443, respectively.

Important note

In the event that you try and connect to your SQL pool or SQL on-demand database in your Synapse workspace after creating it, you could experience a network...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image