Getting Started with Power BI – What is Desktop, Service, Free, Pro, Premium, Embedded and Mobile

Power BI is Microsoft’s cloud-based Business Intelligence Suite. Understanding how the pieces fit together can be a little challenging. In this post, I will discuss what Power BI is and how all the pieces fit together. Power BI consists of: Power BI Desktop Power BI Service Power BI Report Server Power BI Mobile Let’s look at each of these. Power BI Desktop Power BI Desktop is a downloadable tool that … Continue reading Getting Started with Power BI – What is Desktop, Service, Free, Pro, Premium, Embedded and Mobile

Installing Power BI Desktop for Power BI Report Server

To install Power BI Desktop for Report Server, go to the download page and click Download:   Select the PBIDesktopRS version: Run the exe and click Next: Click Next: Click Next: Click Install: Click Finish and launch: Power BI Desktop Report Server will launch:  

Installing Power BI Report Server

To install Power BI Report Server, go through the following steps. First, download the software at https://powerbi.microsoft.com/en-us/report-server/. Select Advanced Download Options: Select Download: And PowerBIReportServer.exe: Run the downloaded exe and select Install Power BI Report Server: Note the options: Click Next: Click Next: Click Install: Click Configure Report Server: Click to Connect: You are now connected: Click on Web Service URL and Apply: And Web Portal URL and Apply: Click on … Continue reading Installing Power BI Report Server

Power BI Home

As announced at the Business Applications Summit 2018 and shown by Power BI Product Manager Nikhil Gaekwad, Power BI’s user landing page will be revamped as “Power BI Home”. I believe Power BI Home will be impactful in the following ways: Help drive user adoption and engagement Expose users to new and existing content Give users the ability to find data quickly Draw in other users in an almost Slack/Teams … Continue reading Power BI Home

Setting up an App Workspace in Power BI and Assigning User Permissions

To create an app workspace, log into https://www.powerbi.com. You will see the screen below. Click on Workspaces->Create app workspace: You will see below: Enter a name and description: The workspace will load: You can also access the new workspace under the Workspaces: Go to My Workspace and select the created workspace. Select Workspace Settings: From here, you can change the name and description of the workspace, as well as delete … Continue reading Setting up an App Workspace in Power BI and Assigning User Permissions

Finding Reports and Datasets in Power BI Apps

In previous versions of Power BI, on installing a Content Pack, dashboard, reports and datasets would be installed in the My Workspace area of the Power BI service: With Power BI Apps, the evolution of Content Packs, these assets are now bundled within the App. Below is an example of an App installed – you can see the user has no Dashboard, Reports and Datasets under My Workspace when the … Continue reading Finding Reports and Datasets in Power BI Apps

Sharing an App with a User in Power BI

In this post we will look at how to share an App with a user in Power BI. Our admin user, MOD Administrator, has installed an app, Sales Analytics for Dynamics 365: We now need to share this with our user, Alan Steiner. When Alan logs in, he sees no apps: Back as Administrator, select the App and click Share: You will see the Share dashboard page. Enter the user … Continue reading Sharing an App with a User in Power BI

Power BI Dynamics 365 The Given Url Neither Points to an OData Service or a Feed

In Power BI, when you connect to the Dynamics 365 (Online) connector, you may see the error “The Given Url Neither Points to an OData Service or a Feed”. To receive this error, in Power BI, connect to Dynamics 365: Enter your Org Url: And see the error: The problem here, is you entered the Org Url not the Web API Url. Enter the following, e.g. https://yourorg.api.crm.dynamics.com/api/data/v9.1/: You can now … Continue reading Power BI Dynamics 365 The Given Url Neither Points to an OData Service or a Feed

Query Folding in Power BI

Query folding is a feature in Power BI that is designed for query optimization. We will go through an example to explain how it works. Consider we have a SQL database, WideWorldImporters, that has a table, [Sales].[Customers]: Let’s pull this data into Power BI desktop. Note we will not enter a SQL statement at this point, but rather select the table and perform filtering later: Select the [Sales].[Customers] table: Click Load to … Continue reading Query Folding in Power BI