A really important reminder for all partners with customers here in Australia. Please ensure you check that your customers have requested to move your Office 365 service to the Australian datacentres, if your service was originally setup elsewhere. The deadline for requests is Monday 31st October 2016, and after that time you will have missed your chance…
Australian Office 365 Education customers: you have 2 weeks left to opt-in to be moved to the Australian datacentre
This is a really important reminder for our education customers here in Australia. Please, please check that you have requested to move your Office 365 Education service to the Australian datacentres, if your service was originally setup elsewhere. The deadline for requests is the end of Monday 31st October 2016, and after that time you…
[Power BI] DAX 入門 (5) 累計、年度をまたいだ累計 #powerbi #ssas #powerpivot
Microsoft Japan Data Platform Tech Sales Team 土井 貴彦 DAX 入門 第 5 回目では累計について説明していきます。 ■年度累計、四半期累計、月度累計 DAX では非常に簡単に累計を求めることができます。まずあらかじめ用意されている累計関数として以下の関数があります。 TOTALYTD 関数 ・・・ 年度累計値を算出します TOTALQTD 関数 ・・・ 四半期累計値を算出します TOTALMTD 関数 ・・・ 月度累計値を算出します では実際にサンプルデータで使い方を見ていきましょう。今回は 気象庁 で公開されている 台風のデータ を使います。 Web 上の情報を簡単に取り込むことができるのも Power BI の特徴です。今回はデータを取得するところは省略しますが、こちら や こちら を参照していただければ、 下記赤枠部分でどんなステップを適用しているかがお分かりいただけるかと思います。サンプルは こちら からダウンロードしてお試しください。 上記の サンプル をダウンロードいただくと、下記のように カレンダーテーブル と 台風の発生数テーブル があることが確認できます。カレンダーテーブルの作成方法は…
Loading SSAS Tabular Databases in SSMS fails for Non-admin users with “Failed to retrieve data for this request”
I was working with one of my customers where he came across the following issue. I thought of sharing the info related to this, because I didn’t find any articles online that talks about this issue. The issue is, users are getting the below error when they are connecting to SSAS tabular instance using SQL…
[Sample Of Oct.19] How to using Entity Framework DB First in ASP.NET Core
Oct. 19 Sample : https://code.msdn.microsoft.com/How-to-using-Entity-1464feea This sample demonstrates how to using Entity Framework DB First in ASP.NET Core. You can find more code samples that demonstrate the most typical programming scenarios by using Microsoft All-In-One Code Framework Sample Browser or Sample Browser Visual Studio extension. They give you the flexibility to search samples, download samples on demand,…
[Sample Of Oct. 19] 如何用Azure Web App Services接入微信公众号
Oct. 19 Sample : https://code.msdn.microsoft.com/How-to-use-Azure-Web-App-f32dc94c 示例演示 如何用Azure Web App Services接入微信公众号. You can find more code samples that demonstrate the most typical programming scenarios by using Microsoft All-In-One Code Framework Sample Browser or Sample Browser Visual Studio extension. They give you the flexibility to search samples, download samples on demand, manage the downloaded samples in a centralized place,…
Migrating Oracle to SQL Server using SSMA – Error: Cannot find either column “ssma_oracle” or the user-defined function or aggregate “ssma_oracle.rpad_varchar”
Issue: You are trying to migrate server objects and data from Oracle to SQL Server using SSMA for Oracle and for a particular view which has the RPAD function and getting the following error while performing database synchronization. Errors: Cannot find either column “ssma_oracle” or the user-defined function or aggregate “ssma_oracle.rpad_varchar”, or the name is…
Performing Transaction Log Backups using AlwaysOn Availability Group Read-Only Secondary Replicas – Part 1
This is the first post in a planned series of articles relating to SQL Server Transaction Log Backups of databases using a read-only secondary replica (ROSR). With the introduction of ROSRs in SQL Server 2012, administrators can now perform full database (copy only) backups as well as transaction log backups on one of the secondary…
Fixing error “The Request uses too many resources.” In CSOM / REST operation
Added a new blog post on SharePoint Developer Support Team Blog. Below is the link Fixing error “The Request uses too many resources.” In CSOM / REST operation
.NET Core – Getting started with GIT and VSCode via Visual Studio Team Services
In this post I show how to use Visual Studio Team Services (formerly Visual Studio Online) to create a GIT repository to host a .NET Core project created using Visual Studio Code. It is valid to say that VSTS allows you to create projects for several languages, IDEs and platforms. Emphasizing that the…