service

Adam looks at the different sharing and collaboration items within Power BI. From the share button to apps and embedding options. Power BI offers many options.

Power Bi Service Dataflows is still underestimated. It is a revolution in Power BI and allows to perform your own data refresh logic, even the incremental refresh for some cases

We are happy to announce that we have just released the February update for the On-premises data gateway (version 3000.1.257) This month’s Gateway update includes an updated version of the Mashup Engine, which matches the … Continue reading “On-premises data gateway February update is now available”

We are happy to announce that we have just released the February update for the On-premises data gateway (version 3000.1.257) This month’s Gateway update includes an updated version of the Mashup Engine, which matches the … Continue reading “On-premises data gateway February update is now available”

In modern BI projects, understanding the flow of data from the data source to its destination, and understanding the data transformation done along the way, is a key challenge for many customers. This challenge becomes even bigger if you have built advanced analytical projects spanning multiple data sources, artifacts, and dependencies. Questions like “What happens … Continue reading “Power BI data lineage experience for dataflows”

Microsoft released the new Template Apps recently, and I am extremely happy to share my first App with you. It is publicly available on Microsoft AppSource. You can now explore Power BI Custom visuals via my Power BI Template App, and share it with your end-users in your organization for free from here. Do you …

This post contains a PowerShell script that triggers a refresh process for three Power BI datasets. Additionally, this script is called/executed as part of automated processes via SQL Server Agent …

In the last post, the process of using Cognitive services Text analytics has been presented. In this post, I will show how to user pre-built AI using some predefined machine learning algorithms in Power BI Service in Data flow. I will follow the same example I show in the Azure ML Studio and Power…

With sophisticated models and scalable compute, Artificial Intelligence becomes a realistic tool for data analysts. Power BI helps you get insights from your data. Now, with access to a set of models from Azure Cognitive Services and your custom models in Azure ML, you can easily enrich those insights with AI. Cognitive services in Power BI gives you access … Continue reading “Easy access to AI in Power BI (Preview)”

In modern BI projects, understanding the flow of data from the data source to its destination is a key challenge for many customers.

We are happy to announce the General Availability (GA) of Multi Geo for Power BI Premium! With Multi Geo going GA, you can extend your Power BI tenant to store your users’ data in the geographies covered in the Microsoft Trust Center, except for Power BI Germany, Power BI China operated by 21Vianet or Power … Continue reading “Announcing Power BI Multi Geo General Availability”

Today, we’re excited to announce that Power BI is making it easier for Azure AD B2B Guest users to collaborate with colleagues across organizational boundaries. Rolling out to production this week is a new capability that allows external Guest users to edit and manage content in workspaces, get the full home experience, and to do … Continue reading “Azure AD B2B Guest users can now edit and manage content in Power BI to collaborate better across organizations”

The weekly Power BI Roundup details the latest updates in the Power BI world with this week around dataflows, MBAS 2019, On-Premise Data Gateway

Adam looks at the Power BI Admin Portal and the roles you need to be able to access and manage your Power BI items. This consists of two potential roles within Azure Active Directory or Office 365.

In the last two parts, first how we able to use cognitive service in Power BI service (Data flow) has been explained. Then in the second one, the process of using a Pre-built machine learning model for prediction ( classification, regression, and forecasting) has been explained. In this post, I am going to show how…

Now that Azure Data Lake Storage Gen2 is now based on Azure Storage as its foundation, we have a new level to incorporate into our planning process the file system itself. The file system contains the files and folders, and is equivalent to a container in Azure Blob Storage which contains blobs. In

Most of the focus on Power BI dataflows so far has been on the use of Power Query Online to load data from external data sources. However, when you create a dataflow you also have the option to att…

Explore new ways to distill actionable insights from your data that drive business growth and what’s new with Power BI capabilities bundled in the April 2019 release. Join us for the Business Applications Virtual Launch Event, streaming live on April 2 from 8:00-9:30 AM PDT. This free event will showcase the new features coming in … Continue reading “See What’s Coming Next in Microsoft Power BI”

Level: Advanced This is the second in my series of articles explaining how to use Microsoft Flow, the Azure APIs, the Power BI APIs and SharePoint Online to help make Power BI Premium more affordab…

Level: Advanced This is another one of those articles that has been swirling in my head for a very long time, about 2 years actually. I have long been frustrated by the lack of a suitable scalable…

Dataflows in Power BI are a really interesting capability for centralizing and reusing Power Query logic among many different PBIX files. If you’ve found yourself copying M scripts (Power Query formula language) between files, or creating a library of M scripts then you should look into dataflows.

How to "Predict the future" by using Power BI? Power BI, in the latest release, added support for supervised automated machine learning.This means that Power BI can help predict ‘unknowns’ once it learns from the ‘known’ values. The learning phase is called “training the model” and predicting phase ...

Weekly Power BI RoundUp which details Service and Mobile Updates, On-Premise Data Gateway, Power BI App Workspaces V2, Embedded & Multivariate

Case Microsoft recently introduced Power BI dataflows for self-service ETL or data preparation. It uses an Azure Data Lake Storage (ADLS), ...

Several months ago, we introduced Power BI dataflows as Public Preview. Now, we’re happy to announce that Power BI dataflows are generally available! Power BI dataflows provide business analysts with a self-service data prep and management experience within Power BI, allowing them to collect business data from various sources, clean and transform it — leveraging … Continue reading “Announcing Power BI dataflows general availability”