Author: Miguel Llopis

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . Over the last few weeks, we have released lots of new Power Query & Dataflows features – Here’s a recap of all the features added or improved in this period: Data Transformations and Query Editor enhancements: Diagram View for authoring of queries Schema view Add Column from Examples Web Connector – By Example Data Extraction Fuzzy Matching: Group By – Fuzzy Matching options Cluster Values Copy/Paste Queries between PQ Online and PQ Desktop Copy data from Query Editor preview Formula bar – Query Script mode Multi-select support in Queries ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . Over the past few weeks we have released several new features in Dataflows, allowing users to seamlessly ingest and prepare data that can be widely reused by other users across the Power Platform, including: 7 New Data Connectors: PDF Files Local Folder SharePoint Folder Google BigQuery HDInsight Spark Apache Spark Generic ODBC 40+ New Data Transformations: Combine Files UX Merge Queries – Visual join kind selection Additional Number/Date/DateTime/Duration transformations UX List transformations: Statistics, Sort, Keep/Remove/Reverse items Fill Up/Down Move Columns left/right/beginning/end Replace Errors Other Power Query Authoring Enhancements: Data ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . We’re glad to announce that it is now possible to use Single Sign-On, leveraging Kerberos, when connecting to certain data sources using DirectQuery mode from Power BI. When a user interacts with a DirectQuery report in the Power BI Service, each cross-filter, slice, sorting, and report editing operation can result in queries executing live against the underlying on-premises data source.  When single sign-on is configured for the data source, queries execute under the identity of the user interacting with Power BI (that is, through the web experience or Power ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . We are happy to announce that we have just released the October update for the On-premises data gateway. This month’s Gateway update includes an updated version of the Mashup Engine, which matches the one released as part of the Power BI Desktop October update. This will ensure that the reports that you publish to the Power BI Service and refresh via the Gateway will go through the same query execution logic/runtime as in the latest Power BI Desktop version. Note that there are some Beta connectors (such as the ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . We’re very glad to announce that the September update for the On-premises data gateway is now available for download. This update includes the following enhancements: Personal Mode support for national clouds. Improved Gateway Configuration Experience for Personal Mode. Updated version of the Mashup Engine.You can download this new version and continue reading below for more details about each enhancement. Personal Mode Support for national clouds Starting with this month’s release, customers can use the Personal Mode of the On-premises data gateway when using Power BI in one of the ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . The August update for the On-premises data gateway is now available. This update includes the following improvements: Support for IBM Netezza connector Default to TLS 1.1/1.2 Increased timeout for On-Premises data gateway requests Updated version of the Mashup Engine You can download this new version following this link and continue reading below for more details about each enhancement. Support for IBM Netezza connector The IBM Netezza connector available in Power BI Desktop since June is now also supported by the On-premises data gateway. This support includes the ability to ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . We’re glad to announce that the July Update for the Power BI On-premises data gateway is now available. This update includes the following enhancements: Support for Snowflake connector Support for SAP BusinessWarehouse DirectQuery connector Updated version of the Mashup Engine You can download this new version following this link and continue reading below for more details about each enhancement. Support for Snowflake connector With this month’s Power BI Desktop update the Snowflake connector has been declared Generally Available. This means that the connector is recommended for use in Production ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . Have you ever had trouble figuring out what data transformations you needed to apply on your data in order to get out the desired output? Or, maybe, you knew what data transformations you wanted to apply, but did not quite know where to find them within the Query Editor UX, or had to specify them as a Custom Column formula? Have you ever wished that you could tell Power BI Desktop what data you wanted as the output, and have us magically figure out the set of transformations for ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . A few months ago we released a Preview of the Amazon Redshift connector in Power BI Desktop. This new connector allows users to easily build reports based on their Redshift data, either by importing the data into Power BI Desktop or by using DirectQuery mode. You can find more details about the Redshift connector in Power BI Desktop in this previous blog post. Today we are very excited to announce support for Redshift-based reports in the Power BI Service, allowing users to publish their reports to unlock seamless consumption ... Read More

As part of the Power BI Desktop August Update we are very excited to announce a preview of a new data connector for Snowflake.Snowflake is a cloud-native elastic data warehouse service that makes it easy to bring together data from disparate sources and make it available to all users and systems that need to analyze it. With the new Power BI Desktop connector, users can import data from Snowflake, combine it with data from other sources, and build rich data visuals as part of their Power BI reports.In order to use this new connector, users need to first enable the ... Read More