Synchronously Refreshing a Power BI Dataset using Azure Logic Apps
In this tip we will implement a polling mechanism to verify if the Power BI dataset has refreshed successfully.
2019-12-25
Power BI
Azure Text Analytics and Power BI
In this tip we look at how to analyze textual data to gain insight from freeform text using Azure Text Analytics and Power BI.
2019-12-13
Power BI Filter Pane
Data Filtering | Configurations - In this tip we look at a new feature in Power BI that allows users to filter data in Power BI reports using the new Filter Pane.
2019-11-29
Merging tables in Power BI dataflows with PRO subscription
Power BI dataflows is a powerful self-service ETL tool. However, some features demand the use of Power BI Premium, way more expensive than the PRO version and sometimes inaccessible. In this latest blog post Dennes Torres explores the subject.
2019-11-18
Power BI Workbooks
Power BI Workbooks | Step by Step - In this tip we look at how to work with Power BI workbooks and in the previous tip we looked at working with Power BI datasets.
2019-11-14
How to Create a Pareto Chart in Power BI Desktop
In this tip we look at how to create a Pareto Chart which applies the Pareto principle aka the 80/20 rule using Power BI Desktop.
2019-10-01
Power BI Bubble Map, Shape Map and Filled Map Examples
In this tip we look various map visualizations like Bubble, Shape and Filled Map visualizations you can use with Power BI.
2019-08-09
Microsoft, Think DevOps First
Steve has a few issues with the design of the Power BI Service and their format for storing reports.
2019-06-22
234 reads
Moving a Power BI Data Model to Tabular
Ginger Grant shares a few tricks to make it easier to upgrade from Power BI Data Model to Tabular.
2019-05-31
Streamlining a Power BI Solution
Power BI is an excellent tool for departments or small organisations getting started with their BI solution. Unless some time is spent organising the solution, however, it can become...
2019-05-17
Blogs
Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)
Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...
ANSI_WARNINGS = OFF can break update statements with some SQL features
By Will Assaf
Working on a SQL 2017 database where an external, non-Microsoft application has direct access...
Bring Your Own Key to Azure SQL Database Managed Instance TDE
Last year Azure SQL Database Managed Instance saw the introduction of bring your own...
Forums
Towards an efficient interface between application and database
Comments posted to this topic are about the item Towards an efficient interface between...
How to handle date on temp table when is null or not ?
How to handle date on temp table when is null or not ? I...
Recruitment question
Thanks for fielding this question in advance: We are searching for a Microsoft SQL...
Ask SSC