In this series of blog posts, we will be examining some of the key features of Power BI Desktop, Power Query and the Power BI Service needed to pass exam DA-100: Analyzing Data with Microsoft Power BI. In
Continue readingIn this series of blog posts, we will be examining some of the key features of Power BI Desktop, Power Query and the Power BI Service needed to pass exam DA-100: Analyzing Data with Microsoft Power BI. In
Continue readingIn this series of blog posts, we will be examining some of the key features of Power BI Desktop, Power Query and the Power BI Service needed to pass exam DA-100: Analyzing Data with Microsoft Power BI. In
Continue readingIn this series of blog posts, we will be examining some of the key features of Power BI Desktop, Power Query and the Power BI Service needed to pass exam DA-100: Analyzing Data with Microsoft Power BI. In
Continue readingThis blog post will show you how to Easily Change All Data Sources from Excel to SQL Server in a given solution. The idea of using power query parameters to rapidly change which data sources your tables
Continue readingConnecting to Web Data (Get Data – Web) When connecting to web data (Get Data – Web), connecting to a web URL does not imply any specific format. The file being accessed via the web may be
Continue readingReplicating Qlik Sense Keep Operations in Power Query turns out to be fairly straightforward. I was recently asked by a client whether the Keep operations present in Qlik Sense could be replicated in Power
Continue readingConnecting to SharePoint Folders is similar to connecting to folders on your file system. The Get Data > Folder connector allows you to connect to a folder containing files of the same type and combine
Continue readingIn Power BI, you can create dynamic titles for any visuals, by creating DAX measures which track the current state of the fields displayed within the visual itself or other related slicers and visuals.
Continue readingIn this post, we will contrast the importing of SQL Server data with working in DirectQuery Mode. When you use the DirectQuery option, data is not imported from SQL Server into the data model of your SQL
Continue reading