Posts

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

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

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

Date Tables in Power BI are used to display dates in reports, filter by dates in reports, and use time intelligence functions in Power BI. Date Tables can be created in DAX or Power Query M Language. To create a really simple date table using DAX, you can use CALENDAR or CALENDARAUTO functions. Both these functions will create a table with one field, a Date field. For example, go to … Continue reading Creating a Really Simple Date Table in Power BI

In Power BI, we can create Date Tables to work with time intelligence. One step in this process is to mark the table as a date table, so Power BI knows to use the table for this purpose. To do this, select your dates table in Power BI Desktop and go to the Modeling tab, select Mark as Date Table: Select the date column from the date table and click OK: … Continue reading How to Mark a Date Table in Power BI