Configuring Power BI Gateway Data Sources For Files And Folders

Configuring Power BI Gateway Data Sources For Files And Folders
by Chris Webb

… “building a lot of Power BI reports from csv and Excel files, and to make sure that scheduled refresh works I have been setting up data sources in an On Premises Data Gateway (what used to be called the Enterprise Gateway). I had assumed that if I was connecting to file-based data sources in my Power BI dataset then, in the gateway, I would need to set up one data source for each file that I’m connecting to – which is a bit of a pain. In fact it turns out that you can set up a gateway data source for the folder that the files are in instead” … https://blog.crossjoin.co.uk/2017/07/14/configuring-power-bi-gateway-data-sources-for-files-and-folders/

Chris Webb's BI Blog

Recently I’ve been building a lot of Power BI reports from csv and Excel files, and to make sure that scheduled refresh works I have been setting up data sources in an On Premises Data Gateway (what used to be called the Enterprise Gateway). I had assumed that if I was connecting to file-based data sources in my Power BI dataset then, in the gateway, I would need to set up one data source for each file that I’m connecting to – which is a bit of a pain. In fact it turns out that you can set up a gateway data source for the folder that the files are in instead.

Let me give you an example. Imagine that you have three Excel files in a folder called C:Sales Data:

image

Now imagine that you have three queries in Power BI that get data from these three files:

image

Here’s an…

View original post 180 more words

Microsoft’s new iPhone app narrates the world for blind people

Microsoft Seeing AI.jpg

“Microsoft has released Seeing AI — a smartphone app that uses computer vision to describe the world for the visually impaired. With the app downloaded, the users can point their phone’s camera at a person and it’ll say who they are and how they’re feeling. They can also point it at a product and it’ll tell them what it is. All of this is done using artificial intelligence that runs locally on their phone”…

https://www.theverge.com/2017/7/12/15958174/microsoft-ai-seeing-app-blind-ios

Webinar: Parallelize R Code Using Apache® Spark™ on August 15th, 2017

R is the latest language added to Apache Spark, and the SparkR API is slightly different from PySpark. SparkR’s evolving interface to Apache Spark offers a wide range of APIs and capabilities to Data Scientists and Statisticians. With the release of Spark 2.0, and subsequent releases, the R API officially supports executing user code on distributed data. This is done primarily through a family of apply() functions.

In this Data Science Central webinar, we will explore the following:
• Provide an overview of this new functionality in SparkR
• Show how to use this API with some changes to regular code with apply()
• Focus on how to correctly use this API to parallelize existing R packages
• Consider performance and examine correctness when using the apply() family of functions in SparkR

Speaker:
Hossein Falaki, Software Engineer — Databricks Inc.

Hosted by: Bill Vorhies, Editorial Director — Data Science Central
Title: Parallelize R Code Using Apache® Spark™
Date: Tuesday, August 15th, 2017
Time: 9:00 AM – 10:00 AM PDT

http://newsletter.datasciencecentral.com/click.html?x=a62e&lc=NaT&mc=j&s=sCt&u=F&y=W&

Build a Node.js or Java web app for Azure Cosmos DB

Simple Java Web App for Cosmos DB
These two articles for Node.js and Java are tutorials that explores how to use Microsoft Azure Cosmos DB to store and access data from a Node.js Express or Java web application hosted on Azure Websites.

https://docs.microsoft.com/en-us/azure/cosmos-db/documentdb-nodejs-application
and
https://docs.microsoft.com/en-us/azure/cosmos-db/documentdb-java-application

Deploying, Securing, and Updating Power BI Reports

via Simple Talk

“Before Excel and other data-linked spreadsheets, business reports needed to be hand-crafted by IT experts, and changes were arbitrated slowly via change control. Power BI was designed to take the liberation that Excel pioneered to the max, by allowing ‘power’ users to not only to create Power BI desktop reports, graphics and visualizations in Power BI App, but then link and publish these to the Power BI app. These in turn can be given row level security and have their underlying data kept up-t…”

https://www.red-gate.com/simple-talk/sql/bi/deploying-securing-updating-power-bi-reports/

Develop locally with the Azure Cosmos DB Emulator

CosmosDB Emulator
The Azure Cosmos DB Emulator provides a local development environment that emulates the Azure Cosmos DB service. Using this you can develop and test your application locally, without the need for an Azure subscription or incurring any costs. Once development is complete and you are ready, you can switch across to using an Azure Cosmos DB account in the cloud.

This is a handy article which covers the following tasks:

  • Installing the Emulator
  • Running the Emulator on Docker for Windows
  • Authenticating requests
  • Using the Data Explorer in the Emulator
  • Exporting SSL certificates
  • Calling the Emulator from the command line
  • Collecting trace files

https://docs.microsoft.com/en-us/azure/cosmos-db/local-emulator

There are some limitations to the Emulator, when compared to the highly scalable cloud version, below is an outline of some of the differences…

Azure Cosmos DB Emulator Azure Cosmos DB Cloud Service
Supports only a single fixed account and a well-known master key. Key regeneration is not possible. Supports multiple accounts and different master keys. You can regenerate keys any time from Azure Portal
Non scalable. Highly scalable
Does not support larger data sets. Support for large data sets
Does not simulate consistency levels. Different Consistency levels available
Does not simulate multi-region replication. Configurable as part of the platform, as needed basis
Does not support quota override feature. Supports document size limit increases, increased partitioned collection storage etc.
Will not support most recent changes to Cosmos DB platform. Most recent platform updates are available

 

FREE Microsoft eBooks, including: Windows 10, Office 365, Office 2016, Power BI, Azure via Eric Ligman, Microsoft Director of Sales Excellence

Topics include Windows 10, Office 365, Office 2016, Power BI, Azure, Windows 8.1, Office 2013, SharePoint 2016, SharePoint 2013, Dynamics CRM, PowerShell, Exchange Server, System Center, Cloud, SQL Server and more…

https://blogs.msdn.microsoft.com/mssmallbiz/2017/07/11/largest-free-microsoft-ebook-giveaway-im-giving-away-millions-of-free-microsoft-ebooks-again-including-windows-10-office-365-office-2016-power-bi-azure-windows-8-1-office-2013-sharepo/

Introducing Microsoft R Server 9.1 release

“Expert data scientists are adopting Advanced Analytics (AA) and Machine Learning (ML) at a rapid pace. This pace can be significantly increased when enterprise-grade AA and ML are available within environments where the customers’ data is, infusing intelligence into mission-critical applications is made much easier and, enterprises can turn to a single vendor to make the world of AA and ML synthesized and supported with the SLAs they have come to expect. At Microsoft, our mission has been to make this vision of ambient intelligence a reality for our customers. We took the first step with Microsoft R Server 9.0 (https://blogs.technet.microsoft.com/machinelearning/2016/12/07/introducing-microsoft-r-server-9-0/), and this follow on release includes significant innovations such as:

• New machine learning enhancements and inclusion of pre-trained cognitive models such as sentiment analysis & image featurizers
• SQL Server Machine Learning Services with integrated Python in Preview
• Enterprise grade operationalization with real-time scoring and dynamic scaling of VMs
• Deep customer & ISV partnerships to deliver the right solutions to customers
• A panoply of sources to help you get started with ease

You can immediately download Microsoft R Server 9.1 from MSDN (https://aka.ms/rserver9.1) and Visual Studio Dev Essentials (https://aka.ms/rserver9.1.myvs). It comes packed with tons of value built on top of the latest open source R engine that makes R enterprise-class. Also check out R Client for Windows (http://aka.ms/rclient) and R Client for Linux (http://aka.ms/rclientlinux).”…

read more at https://blogs.technet.microsoft.com/dataplatforminsider/2017/04/19/introducing-microsoft-r-server-9-1-release/