Power BI DirectQuery can have performance implications. Bob Ward shares his knowledge to help make SQL Databases perform better! Automatic tuning: https://docs.microsoft.com/azure/sql-database/sql-database-automatic-tuning ColumnStore Indexes: https://docs.microsoft.com/azure/sql-database/sql-database-in-memory Forced parameterization: https://docs.microsoft.com/sql/relational-databases/performance/specify-query-parameterization-behavior-by-using-plan-guides?view=sql-server-ver15 Intelligent Query Processing: https://docs.microsoft.com/sql/relational-databases/performance/intelligent-query-processing?view=sql-server-ver15 PolyBase: https://docs.microsoft.com/sql/relational-databases/polybase/polybase-guide?view=sql-server-ver15
Not Folding; the Black Hole of Power Query Performance (@Rad_Reza) Calling Microsoft Flow From Power Query And Power BI (@technitrain) Analysis Services Tabular Is (Finally) NUMA-Aware! (@SQLbyoBI) What’s new in SQL Server 2016 SP1 for Reporting Services What's New in SQL Server vNext BONUS: Excel Workbook Connection to Local Power BI Desktop (@ExceleratorBI) Grouping and [...]
I have four tips for troubleshooting connectivity with the On-Premises Data Gateway on Power BI. These tips apply to any client application. Troubleshooting connectivity For this post, we will use an example of getting an error when trying to connect to a SQL Server named instance. In this case, we get an error when [...]
I look at the difference between paginated and mobile reports within Reporting Services 2016. Mobile reports are new with SQL Server Reporting Services 2016 and you may be confused as to what they are as compared to paginated reports. Paginated Reports Paginated reports are operational reports that allow for a more traditional report experience. Mobile [...]
SQL Server has GA'd!!! We also had a lot of updates for Power BI! Creating Current Day, Week, Month And Year Reports In Power BI Using Bidirectional Cross-Filtering And M (@technitrain) Power BI Desktop May Update Feature Summary Smarter Auto-Generated Insights with Complex Filters Power BI gateways – May Update SQL Server 2016 is generally [...]
Donate: https://donate.rednoseday.org/ Red Nose Day: http://rednoseday.org/ Paul Turley gives a recap of the PASS BA conference from his perspective mentioning Power BI and Excel. Jen Underwood talks about moving to Predictive Analytics. We have some tips for Dashboard makeovers. Ginger Grant talks about using R within SQL Server 2016. Power BI and Excel–the Dynamic Duo [...]
I walk through using a DirectQuery connection with SQL Server and the Power BI service. I start with Power BI Desktop, show how to configure the enterprise gateway, and then show how it looks in the Power BI service.