One of the most exciting features of the new Power BI Preview is the ability to connect live to Analysis Services tabular models that live on-premise though the SSAS connector. In this article we will show you step by step how to securely connect an on-premises Analysis Services Tabular mode instance to use it as a data source in the Power BI Preview. You can alternatively use a virtual environment in Azure (IaaS). The process is similar.
Unlike caching the data in the Power BI service, with the new Analysis Services Connector you can connect from Power BI to your on-premises Analysis Services Tabular model & build dashboards, reports. The DAX queries issued by Power BI are sent to the Analysis Services Connector which in turn sends it to the tabular model. The DAX query is executed according to the role based permissions defined in the model. The connector will interactively query the on-premises cube to fetch the data using your Active Directory credentials. With this new option, you can continue to manage and secure your data on-premises, removing the need to have data reside in the cloud.
Power BI Analysis Services Connector Deep Dive - PowerBI - Site Home - MSDN Blogs
Thursday, October 8, 2015
Microsoft Connects Power BI to On-Premises SQL with Preview Tool | SQL Server content from SQL Server Pro
Microsoft spent a good number of development cycles in the last half of 2014 delivering tools to help customers connect various on-premises operations to the Azure Cloud. Various improvements were made and some tools were deprecated in lieu of combined and enhanced offerings. One of those, the Azure AD Sync Service that released in October, delivered a full sync between on-premises Active Directory with Azure Active Directory, ensuring a mirrored infrastructure.
Microsoft Connects Power BI to On-Premises SQL with Preview Tool | SQL Server content from SQL Server Pro
Microsoft Connects Power BI to On-Premises SQL with Preview Tool | SQL Server content from SQL Server Pro
SQL Server Analysis Services Tabular data in Power BI – Microsoft Power BI
In Power BI, there are two ways you can connect to SQL Server Analysis Services Tabular model data. In Get data, you can connect to a SQL Server Analysis Services server, or you can connect to an Excel workbook that already connects to an Analysis Services server. If your Excel workbook has reports based on your tabular data, you’ll be able to explore and edit them right in Power BI.
SQL Server Analysis Services Tabular data in Power BI – Microsoft Power BI
SQL Server Analysis Services Tabular data in Power BI – Microsoft Power BI
Tuesday, October 6, 2015
HOW TO GET 1,000+ Followers ON TWITTER
We have some good news and some bad news.
The bad news: Unless you’re famous, it’s really difficult to amass a huge
following on Twitter without some hard work. For the average person or
business, growing your following takes time and attention on a daily basis.
The good news: There are a few big levers you can pull to quickly collect at
least 1,000 quality followers for your personal or professional Twitter
account. You just need to know how to invest your time and effort.
successonthefly.com/Reports/HowToGet1000+FollowersOnTwitter.pdf
The bad news: Unless you’re famous, it’s really difficult to amass a huge
following on Twitter without some hard work. For the average person or
business, growing your following takes time and attention on a daily basis.
The good news: There are a few big levers you can pull to quickly collect at
least 1,000 quality followers for your personal or professional Twitter
account. You just need to know how to invest your time and effort.
successonthefly.com/Reports/HowToGet1000+FollowersOnTwitter.pdf
Cate Blanchett: selfies are 'pathetic'
"People constantly are taking pictures of ourselves to send them to people to see if they like me, 'Do they like me?' said the stunning 46-year-old, who has put her her vanity aside for roles such as Blue Jasmine's Jasmine, where she went completely make-up free.
"It's pathetic, the whole thing about people worrying about what other people are going to think. I just can't handle it.
"Of course you want people to go see the film that you make, of course you want them to enjoy them. But I'm not out there saying, 'Do they like the way I look?'… You have to say, 'This is what I'm doing right now.'"
The mum-of-four added that although social media can be a "genuine way to build community", it can also create jealousy and a sense that the grass is always greener.
"Comes back to self-respect," Blanchett said. "It's this huge thing. 'Like me! Like me!.' The like and the dislike is just totally primary schoolyard.
Cate Blanchett: selfies are 'pathetic'
"It's pathetic, the whole thing about people worrying about what other people are going to think. I just can't handle it.
"Of course you want people to go see the film that you make, of course you want them to enjoy them. But I'm not out there saying, 'Do they like the way I look?'… You have to say, 'This is what I'm doing right now.'"
The mum-of-four added that although social media can be a "genuine way to build community", it can also create jealousy and a sense that the grass is always greener.
"Comes back to self-respect," Blanchett said. "It's this huge thing. 'Like me! Like me!.' The like and the dislike is just totally primary schoolyard.
Cate Blanchett: selfies are 'pathetic'
Subscribe to:
Posts (Atom)