PASS Summit 2016 / SQL Clinic Recap

Last week was PASS Summit 2016, and I spent a lot of time in the SQL Clinic answer your questions! I wanted to highlight a few of the questions that I was asked in the Clinic and share that out with everyone.

PASS Summit 2016 / #SQLFamily montage
https://www.youtube.com/watch?v=0R2wL1oMFrg

Questions:

1. Can you use a wildcard SSL certificate with SQL Server or Reporting Services?

2. Does the On-Premises Data Gateway use Kerberos?

3. Why is importing from SSAS different from using a live connection when working with fields?

4. Can we use an AlwaysOn Availability Group with a data source in the Gateway? Specifically using a Secondary replica.

connect to alwayson secondary replica
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9285198-connect-to-alwayson-secondary-replica

5. Can we leverage SQL 2016 Row-Level Security, specifically session_context, when using a data source with the Gateway in Power BI?

Leverage SQL Server 2016 Row-Level Security for Power BI Desktop published reports/datasets
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/14216322-leverage-sql-server-2016-row-level-security-for-po

6. Can we migrate reports in Reporting Services from one instance to another?

2017-03-16T09:01:11+00:00