sqlitybi.com Open in urlscan Pro
188.68.240.143  Public Scan

Submitted URL: http://sqlitybi.com/
Effective URL: https://sqlitybi.com/
Submission: On April 06 via api from CH — Scanned from DE

Form analysis 3 forms found in the DOM

GET https://sqlitybi.com/

<form role="search" method="get" class="search-form" action="https://sqlitybi.com/">
  <label>
    <span class="screen-reader-text">Search for:</span>
    <input type="search" class="search-field" placeholder="Search …" value="" name="s">
  </label>
  <input type="submit" class="search-submit" value="Search">
</form>

GET https://sqlitybi.com/

<form role="search" method="get" class="search-form" action="https://sqlitybi.com/">
  <label>
    <span class="screen-reader-text">Search for:</span>
    <input type="search" class="search-field" placeholder="Search …" value="" name="s">
  </label>
  <input type="submit" class="search-submit" value="Search">
</form>

<form id="jp-carousel-comment-form">
  <label for="jp-carousel-comment-form-comment-field" class="screen-reader-text">Write a Comment...</label>
  <textarea name="comment" class="jp-carousel-comment-form-field jp-carousel-comment-form-textarea" id="jp-carousel-comment-form-comment-field" placeholder="Write a Comment..."></textarea>
  <div id="jp-carousel-comment-form-submit-and-info-wrapper">
    <div id="jp-carousel-comment-form-commenting-as">
      <fieldset>
        <label for="jp-carousel-comment-form-email-field">Email (Required)</label>
        <input type="text" name="email" class="jp-carousel-comment-form-field jp-carousel-comment-form-text-field" id="jp-carousel-comment-form-email-field">
      </fieldset>
      <fieldset>
        <label for="jp-carousel-comment-form-author-field">Name (Required)</label>
        <input type="text" name="author" class="jp-carousel-comment-form-field jp-carousel-comment-form-text-field" id="jp-carousel-comment-form-author-field">
      </fieldset>
      <fieldset>
        <label for="jp-carousel-comment-form-url-field">Website</label>
        <input type="text" name="url" class="jp-carousel-comment-form-field jp-carousel-comment-form-text-field" id="jp-carousel-comment-form-url-field">
      </fieldset>
    </div>
    <input type="submit" name="submit" class="jp-carousel-comment-form-button" id="jp-carousel-comment-form-button-submit" value="Post Comment">
  </div>
</form>

Text Content

Skip to content

sqlitybi


 * Search for:

 * Home
 * About
 * Contact
 * Subscribe
 * Categories
   * Azure
     * Azure Analysis Services
     * Azure Data Factory
     * Azure Automation
     * Azure Dev Ops
     * Azure Monitor
   * PowerBI
   * SQL Server
     * SQL
   * Other
     * SQL Server Data Tools (SSDT) VS
     * PowerShell
   * Analysis Services
     * Analysis Services Tabular
     * Analysis Services Multidimensional

 * Home
 * About
 * Contact
 * Subscribe
 * Categories
   * Azure
     * Azure Analysis Services
     * Azure Data Factory
     * Azure Automation
     * Azure Dev Ops
     * Azure Monitor
   * PowerBI
   * SQL Server
     * SQL
   * Other
     * SQL Server Data Tools (SSDT) VS
     * PowerShell
   * Analysis Services
     * Analysis Services Tabular
     * Analysis Services Multidimensional

Search for:


SQLITYBI


SQLITYBI


A WORLD OF BUSINESS INTELLIGENCE

2

Azure / SQL Server

March 11, 2022

 by Jesse

 by Jesse · Published March 11, 2022


HOW TO BULK LOAD DATA FROM AZURE BLOB TO AZURE SQL DATABASE

In this post, I would like to show you how you can bulk load data from Azure
Storage Account into Azure SQL Database. I will be using a CSV dataset for this
demonstration. I have created a new Azure SQL Database table with the same
metadata structure as the CSV data source. To get started, you need to make the
table inside Azure SQL Database, where you will INSERT the data from Azure Blob.
Create a MASTER KEY Then you...

0

Other / SQL Server Data Tools (SSDT) VS

February 16, 2022

 by Jesse

 by Jesse · Published February 16, 2022


HOW TO SWAP REFERENCED DACPACS IN DB PROJECT DYNAMICALLY

In this post, I would like to show you how to dynamically parameterize the SQL
database projects project settings. Some examples include dynamically changing
the version, referenced databases, items, and configurations. These dynamic
settings can be set inside Azure DevOps, as an example, for different customer
builds and environments, each with its unique settings. To demonstrate, I will
use XML PropertyGroup’s and MSBuild’s arguments. Let’s say that you have the
requirement to build based on different source DACPACs dynamically. These source
DACPACs could have different versions. Therefore,...

0

PowerBI

October 20, 2021

 by Jesse

 by Jesse · Published October 20, 2021 · Last modified February 5, 2022


ODD DECIMALS WHEN DIVIDING BY 100 OR USING DIVIDE IN POWER BI

Recently I had the requirement to expose the Average Interest Rate percentage in
a Power BI report, which the database stored in the below format. Typically the
fastest way to format this as a percentage is to change the
Format type to Percentage. However, by using the format type Percentage, the
value automatically gets multiplied by 100. Therefore, you need to either
use /100 or DIVIDE on your measure. Naturally, this gives us the correct answer
visually, as seen in the image below. Dax measures used: Example /100 =
AVERAGE(Example[Interest Rate])/100...

0

Azure / Other

July 22, 2021

 by Jesse

 by Jesse · Published July 22, 2021


HOW TO EXTRACT HIDDEN AZURE RESOURCE MANAGER TEMPLATES

While working with Azure, I like to implement all my Azure resources as
infrastructure as code using Azure Resource Manager (ARM) Templates. Most Azure
resources allow us to Export the ARM templates using the Export Template menu
item under Automation inside the Azure portal – since it isn’t always easy to
know how to create the ARM template from scratch without some starting point.
However, in most cases, the ARM templates exported using Export Template are
often broken, contain partial...

0

Azure / Azure Data Factory / Other

June 30, 2021

 by Jesse

 by Jesse · Published June 30, 2021


POST AZURE DATA FACTORY PROCESSING STATUS TO MICROSOFT TEAMS

In this post, I would like to show you how to build a pipeline that will use a
REST API to retrieve the Azure Data Factory pipeline run status. It will then
use a web activity to send a status message to the Microsoft Teams channel via a
webhook. This method will allow application monitoring teams to get a meaningful
message with the description and location of the error inside the Azure Data
Factory. Additionally, this allows easier collaboration for...

2

Azure

May 31, 2021

 by Jesse

 by Jesse · Published May 31, 2021


HOW TO CREATE AZURE AD USERS ON AZURE SQL DATABASE

This article will show you how to create Azure AD user’s identities on Azure SQL
Database to authenticate using Azure Directory accounts. If you start to use
Azure SQL Database for the first time, you may notice that we have many fewer
features in on-premise SQL databases. For example, we had many handy GUI
interfaces that allowed us to create logins and control security permission.
This is not the case for Azure SQL Database; to create logins and configure
security,...

 * 
 * Next Page »

Follow:

 * 
 * 
 * 
 * 

 * Popular Posts
 * Recent Posts
 * Recent Comments
 * Tags

 * Azure / SQL Server
   
   How to Bulk Load Data from Azure Blob to Azure SQL Database
   
   11 Mar, 2022

 * Other / SQL Server Data Tools (SSDT) VS
   
   How to Swap Referenced DACPACs in DB Project Dynamically
   
   16 Feb, 2022

 * PowerBI
   
   Odd Decimals When Dividing by 100 or using DIVIDE in Power BI
   
   20 Oct, 2021

 * Azure / Other
   
   How to Extract Hidden Azure Resource Manager Templates
   
   22 Jul, 2021

 * Azure / Azure Data Factory / Other
   
   Post Azure Data Factory Processing Status to Microsoft Teams
   
   30 Jun, 2021

 * Azure / Azure Data Factory
   
   How to Build Your Own Tabular Translator in Azure Data Factory
   
   23 Apr, 2021

 * Azure
   
   How to Create Azure AD Users on Azure SQL Database
   
   31 May, 2021

 * Azure / SQL Server
   
   How to Bulk Load Data from Azure Blob to Azure SQL Database
   
   11 Mar, 2022

 * Azure Analysis Services / PowerShell
   
   How to Execute Analysis Services Cmds using a Service Principal
   
   8 Apr, 2021

 * Analysis Services Tabular / Azure / Azure Analysis Services
   
   Performance Impact of CALCULATETABLE Chaining
   
   16 Apr, 2021

 * Jesse says:
   I have not tried to upload to SharePoint from R before.
 * Rocco says:
   how use write_xlsx with file having path on sharepoint like with...
 * Jesse says:
   I have tried the nested arrays with JSON configurations using the...
 * Yvesvl says:
   Amazing post! Have you managed to try this out with nested...
 * Jesse says:
   Old on-prem habits die hard. Yes, I am aware Azure SQL...

 * ADF ADOMD AMO ARM Automation Account Auto Schedule Data Export Azure Azure
   Analysis Services Azure Data Factory Azure DevOps Azure Resource Manager
   CALCULATETABLE Database Project Hashbytes Incremental Loading INSERT INTO max
   values Measure Group Measure Table Merge Nonclustered Index Performance Power
   BI Power BI Embedded PowerShell Runbook SCD1 Schema Comparison SELECT INTO
   Service Principals Slowly Changing Dimensions SQL SQL Server SQL Server 2019
   SQL Tips SSAS SSDT SSMS Streaming Tabular Tempdb Trace Flag UNION UNION ALL
   XMLA Endpoint


CATEGORIES

 * Analysis Services (1)
 * Analysis Services Multidimensional (2)
 * Analysis Services Tabular (12)
 * Azure (17)
 * Azure Analysis Services (10)
 * Azure Automation (6)
 * Azure Data Factory (5)
 * Azure Dev Ops (2)
 * Azure Monitor (1)
 * Other (6)
 * PowerBI (24)
 * PowerShell (8)
 * SQL (8)
 * SQL Server (20)
 * SQL Server Data Tools (SSDT) VS (8)


RECENT POSTS

 * How to Bulk Load Data from Azure Blob to Azure SQL Database
 * How to Swap Referenced DACPACs in DB Project Dynamically
 * Odd Decimals When Dividing by 100 or using DIVIDE in Power BI
 * How to Extract Hidden Azure Resource Manager Templates
 * Post Azure Data Factory Processing Status to Microsoft Teams

 * Home
 * About
 * Contact
 * Subscribe
 * Categories
   * Azure
     * Azure Analysis Services
     * Azure Data Factory
     * Azure Automation
     * Azure Dev Ops
     * Azure Monitor
   * PowerBI
   * SQL Server
     * SQL
   * Other
     * SQL Server Data Tools (SSDT) VS
     * PowerShell
   * Analysis Services
     * Analysis Services Tabular
     * Analysis Services Multidimensional

sqlitybi © 2022 | Privacy Policy

 * 
 * 
 * 
 * 

 

Loading Comments...

 

Write a Comment...
Email (Required) Name (Required) Website

We use cookies to ensure that we give you the best experience on our website. If
you continue to use this site we will assume that you are happy with
it.AcceptPrivacy Policy