I have listed below the top questions I see from customers about Azure Synapse Analytics and Power BI, and the blogs that I have written that try to answer each question. I have also added these questions to my blogs FAQ page that also includes “Modern data warehouse” and “SQL Server migration to Azure”, which I have updated.
Azure Synapse Analytics
Below are the top questions I am seeing from customers about Azure Synapse Analytics (formally called Azure SQL Data Warehouse), and the blogs that I have wrote that try to answer each question:
- What is the difference between the GA version of Synapse and the one in public preview? Azure Synapse Analytics confusion
- What are the newest features for the SQL Pool? Azure Synapse Analytics new features, Microsoft Ignite Announcements 2020
- What are the performance options when using Synapse and Power BI? Azure Synapse Analytics & Power BI performance
- Can I run Power BI dashboards against Synapse? Azure Synapse Analytics & Power BI concurrency
- Can you explain the new SQL on-demand in Synapse? SQL on-demand in Azure Synapse Analytics
- What is a “Data Lakehouse”? Data Lakehouse & Synapse
- What are all the ways to query data in Synapse? Query options in Azure Synapse Analytics
- Are there samples to use in Synapse? Azure Synapse Analytics overlooked features
- How can I create federated queries in Synapse? Synapse and federated queries
Power BI
Below are the top questions I am seeing from customers about Power BI, and the blogs that I have wrote that try to answer each question:
- What are Composite models and Aggregations? Power BI new feature: Composite models
- What are Dataflows? Can I clean data with Power BI? Power BI: Dataflows, Where should I clean my data?
- What is the Microsoft Power Platform? The Microsoft Power Platform
- Can Power BI access data in ADLS Gen2? Ways to access data in ADLS Gen2
- What are performance options when using Power BI against Synapse? Azure Synapse Analytics & Power BI performance
- Can I use Power BI dashboards against Synapse? Azure Synapse Analytics & Power BI concurrency
- How can I stream data into Power BI and do real-time updates? Power BI Real-time Streaming
- What are the various type of security options in Power BI? Power BI Security
- What are all the ways to share dashboards and reports in Power BI? Power BI Sharing
- What are the ways to monitor performance and usage in Power BI? Monitoring Power BI
- What were the latest announcements about Power BI at Ignite? Microsoft Ignite Announcements 2020
- What are other questions you hear customers asking? Power BI FAQ
The post Top Azure Synapse Analytics and Power BI questions first appeared on James Serra's Blog.
