Category: Microsoft Power BI

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . June was yet another exciting month for Power BI! Read on for a summary of the announcements we made in both the service and mobile. Also, huge thank you for those of you that joined us at the Microsoft Business Applications Summit in Atlanta. For those who couldn’t make it out, you can check out the session recordings in our community MBAS gallery. We hope to see you next year! Shared and certified datasets (Preview) We kicked off June by announcing a public preview of shared and certified datasets ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . We are happy to announce that we have just released the July update for the On-premises data gateway (version 3000.7.147). Here are some of the things that we would like to highlight with this month’s release: .Net Framework Update Encrypted Connection – Bug Fix July version of the mashup engine .Net Framework Update We are using .NET 4.7.2 framework for gateways July 2019 version or higher hence some of the operating systems we used to support may no longer be supported. More information about OS which will be supported ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . It is good practice to check your datasets periodically for refresh errors. A quick way is to view the list of datasets in a workspace, but if you are the admin of many workspaces, checking each workspace individually can get tedious. Refresh notification emails provide a convenient alternative. Just leave the checkbox Send refresh failure notification emails to me enabled in your refresh configuration and verify that spam filters don’t block the messages from Microsoft Power BI. The following screenshot depicts the refresh configuration for a dataset and a ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . Gateway management until recently, supported only one data source definition per data source on an on-premises data gateway. This posed limitations for gateway admins as they couldn’t create multiple data sources to the same data source each with different credentials based on the required security context for each one. The workaround would be to spin up a new gateway for every such new data source. Note: The data source name still needs to be unique for every data source definition. Below you can see that a gateway admin has ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . To kick off July, we’ve dropped the latest update to Power BI Report Builder in the download center.  It includes, for the first time, the ability to connect to your Power BI datasets, whether or not they are backed by premium capacity.  This means any Power BI Pro user can connect to and author, render and export reports locally against her or his Power BI datasets with Power BI Report Builder. NOTE:  For report authors that have been using the XMLA endpoint to connect to Power BI datasets, that functionality ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . We’re almost three weeks post-GA of Paginated Reports in Power BI, and we wanted let you know about several updates we’ve made since then – E-Mail Subscription Enhancements There are two updates we wanted to highlight in regards to e-mail subscriptions with paginated reports. Edit Parameters in your subscription You can now see the parameter values currently set for the selected subscription by expanding the “View parameters” item in the subscription pane If you want to change these values, you may now update the parameters for your selected subscription ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . We are excited to announce the recent release of support for $expand in the GetGroupsAsAdmin API! As a Power BI service admin if you need to list all workspaces in your tenant, including their users, reports, dashboards, and datasets, $expand helps you do this quickly and efficiently. Support for $expand in the GetGroupsAsAdmin API enables you to retrieve the details of the navigation properties for users, reports, dashboards, and datasets directly in the workspace properties. You no longer need to loop through each workspace and call 4 separate APIs. With $expand, you can accomplish that work with a single API call. This makes your solutions dramatically simpler, more intuitive, faster to develop, and easier to maintain ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . Dataflows help organizations unify data from disparate sources and prepare it for reusability. You can use dataflows to ingest data from a large and growing set of supported sources including Dynamics 365, Salesforce, Azure SQL Database, Excel, SharePoint, and more. You can then map data to standard entities in the Common Data Model, in Azure Data Lake Storage Gen2. Ingesting data can sometimes be tedious and time consuming, especially when the schema between the source and destination is different. A dataflow template can expedite this process by providing a ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . We’re excited to announce we’ve started to roll-out the Viewer role for the new workspace experience, perfect for users who need to view content within workspaces without the ability to modify it. The feature roll-out has started and should complete for commercial cloud customers 6/29/2019. The Viewer role gives a read-only experience to its users. They can view dashboards, reports, or workbooks in the workspace, but can’t browse the datasets or dataflows. Use the Viewer role wherever you would previously use a classic workspace set to “Members can only view ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . We are excited to announce new improvements to Power BI dataflows releasing this month including an enhanced compute engine to drastically improve data refresh times and a new set of dataflow templates to help you easily connect to common data sources mapped against the common data model. Enhanced compute engine As organizations accumulate more and more data, it becomes increasingly important to quickly perform ETL at scale over these datasets. Today we are announcing a major step forward in overcoming these pains points with a new compute engine for ... Read More