Top Azure Synapse Analytics and Power BI questions from Blog Posts – SQLServerCentral

0
216
2 min read

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:

  1. What is the difference between the GA version of Synapse and the one in public preview? Azure Synapse Analytics confusion
  2. What are the newest features for the SQL Pool? Azure Synapse Analytics new featuresMicrosoft Ignite Announcements 2020
  3. What are the performance options when using Synapse and Power BI? Azure Synapse Analytics & Power BI performance
  4. Can I run Power BI dashboards against Synapse? Azure Synapse Analytics & Power BI concurrency
  5. Can you explain the new SQL on-demand in Synapse? SQL on-demand in Azure Synapse Analytics
  6. What is a “Data Lakehouse”? Data Lakehouse & Synapse
  7. What are all the ways to query data in Synapse? Query options in Azure Synapse Analytics
  8. Are there samples to use in Synapse? Azure Synapse Analytics overlooked features
  9. 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:

  1. What are Composite models and Aggregations? Power BI new feature: Composite models
  2. What are Dataflows? Can I clean data with Power BI? Power BI: DataflowsWhere should I clean my data?
  3. What is the Microsoft Power Platform? The Microsoft Power Platform
  4. Can Power BI access data in ADLS Gen2? Ways to access data in ADLS Gen2
  5. What are performance options when using Power BI against Synapse? Azure Synapse Analytics & Power BI performance
  6. Can I use Power BI dashboards against Synapse? Azure Synapse Analytics & Power BI concurrency
  7. How can I stream data into Power BI and do real-time updates? Power BI Real-time Streaming
  8. What are the various type of security options in Power BI? Power BI Security
  9. What are all the ways to share dashboards and reports in Power BI? Power BI Sharing
  10. What are the ways to monitor performance and usage in Power BI? Monitoring Power BI
  11. What were the latest announcements about Power BI at Ignite? Microsoft Ignite Announcements 2020
  12. 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.


The post Top Azure Synapse Analytics and Power BI questions appeared first on SQLServerCentral.