Power BI Service Connected to Azure SQL Server Data set with User credentials

We have an Azure Database which has an Admin UserName and Password

But we have also added the following to the Database In SQL Management Studio

— Create the user with Password for users that authenticate at the database

CREATE USER Org_powerbi WITH PASSWORD = 'password1';

–And Create a role

CREATE ROLE db_Org_read;

–Execute the Stored Procedure addrole member. Here the Org_powerbi user is being added to the above role

EXEC sp_addrolemember 'db_Org_read', ' Org_powerbi';

–We have a schema called org. We are granting the SELECT permission for this schema to the above Role. this means that you can perform Select data Statements

GRANT SELECT ON SCHEMA :: Org TO db_Org_read

So we added a user and granted the user SELECT permissions

When we use this user ID and password in Desktop it works fine. We can refresh the data.

However in Service (Dataset – Schedule Refresh), the login credentials are invalid

Scheduled refresh

Authentication Method – Basic

Choose Basic if you plan to use SQL authentication instead of Windows authentication

Privacy level Setting for this Data Source – Organizational

An Organizational data source limits the visibility of a data source to a trusted group of people. An Organizational data source is isolated from all Public data sources, but is visible to other Organizational data sources.

The Solution

The user account you create needs to be added to the Data Source Credentials in the Power BI Service once the dataset has been uploaded.

Go to Settings

And again. Settings

And Edit Data Source Credentials of the data Set

This will add the user to the Data Source Credentials

Once added you can go back to the Schedule Refresh in the Data set in your app workspace and the Log in Credentials should now work.

Creating New Teams in Microsoft Teams and Power BI App Workspaces (The Classic to New App Workspace issue)

Microsoft teams is your central hub for teamwork so we can all collaborate in one place. its an offering of Office 365.

Microsoft Teams are part of Office 365 Groups
  • You can either, Make a team and connect it to an existing office 365 Group
  • However Creating Teams rather that Office 365 Groups is probably the best solution

Teams can be private or public. They will have an owner and Members and guests.

When you create a new Team channel. For example

And then move to your Power BI Service you will find this …

An App workspace that corresponds to the team. In fact, you have lots of App Workspaces. Only some are actually relevant to power BI. Teams does not create the Power BI workspace. Teams actually creates an O365 group and Power BI uses the O365 groups created

You either

a. Want to work with it as a proper app workspace and add reports and Dashboards

b. Really don’t need it in Power BI and want to get rid

Lets look at these options in more detail

Use the Teams Workspace as an App Workspace

I have data on the training courses offered so I have decided I want to use this app workspace

the Report is published to the App Workspace

Here are the menu items for the Report created over the Teams app Workspace

And here are the menu items for an App workspace that was specifically created in Power BI

Notice that Settings and Access aren’t there. This means you cant collaborate with your team in the Workspace or look at the workspace settings. Why is this?

When New Workspaces are created in Power BI Via Teams, the App Workspace is created as Classic. Not the new Workspace. New Workspaces aren’t tied to the Office 365 Group.

In order to collaborate in classic you need to click on … and go to Members. This takes you to Office 365 and you have to add individual members from here.

We don’t want the Workspace to be tied to Office 365. and we want to change the App workspace from Classic to New

Are you an Admin / Owner of the team?

No. I am a member of this group. Because of this there are no other options to look at in here.

To Upgrade to the New App Workspace you need to be a Group Admin. If the person who created the Teams channel isn’t a regular user you may want to see if you can get yourself admin permissions via the Teams owner


And change from Member to Owner

Now as an owner you can Edit this workspace

You can now See Advanced. click on this to get to the upgrade option

Select Upgrade Now

Once the workspace is upgraded it is no longer tied to the Team or Office 365 and can be used like the standard Power BI New App Workspace.

Delete the App Workspace as its not required

The Team has been created and its now in your Power BI App Workspaces list. Its not required and its just adding extra information into Power BI that is not needed

You are the Owner of the Team and can see this when you go to Workspace Settings


DO NOT DELETE THE WORKSPACE

If at this point you delete the Workspace, its still connected to Office 365 and you will delete everything.

Use the information above to Upgrade the the New App Workspace before deleting.

The App Workspace must be disconnected first by not being a classic Workspace.

And if you want to try this out. test with a small team first. We have done numerous tests and after upgrade the Delete hasn’t removed anything but better to be safe than sorry.

there is a Post on this in Power BI Ideas

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36193693-disable-or-prevent-teams-from-autocreating-app-wor

Setting up a Board in Azure DevOps (AGILE)

Its time to start tracking Projects with Azure DevOps boards.

With Boards, teams can manage software Projects. They can track user stories, backlog items, tasks, features etc. You can choose the environment you want to work with like AGILE or SCRUM.

For this example, there is only one developer (me) and I’m am tracking my progress on a project where I have been the single developer

AGILE is the process that going to be used

Agile is an iterative approach to project management and software development that helps teams deliver value to their customers faster and with fewer headaches. Instead of betting everything on a “big bang” launch, an agile team delivers work in small, but consumable, increments.

First Open Azure DevOPs

https://azure.microsoft.com/en-gb/services/devops/

Sign into your DevOps account.

And create a new Project under your Enterprise

Work Items

Now we have a new project we can start working with Boards but first we need to understand what our AGILE work items are and how they interact with each other.

Epic

I have specific Epics I want to achieve

  • Reporting from the companies main system
  • Social Media reporting
  • Reporting for the Surveys
  • Reporting for all the telephone enquirers
  • Reporting for Complaints
  • Main Reporting Area for all the data Auditing
  • Reporting for Report usage

So, just looking at this. I want 7 Epics to work with (To start with)

Feature

A feature is some complete behavior to implement a new business process. So for example. for the Social Media Epic we want

  • Overall View of Business Performance as provided by the surveys
  • Monthly level reporting on customer satisfaction with drill through

User Stories

User stories are within a feature. These are the smallest change that will result in behavior change. If you don’t observe a change then it cant be demonstrated

For example, as the Customer Satisfaction Manager I want to see the Survey results by month and have the ability to see how we are doing by over the year and at the same point in the year because we need to know if we are doing well as a company to see our trends in satisfaction

As the Company Head of Service I want a full review of our performance using our scoring system against customer satisfaction and how our competitors are doing for benchmarking

Task

These are within a User Story and are the smallest independently deployable change.

  • Get file of Survey data (Pilot project)
  • Move Survey data into the Azure Data Warehouse (Staging area) Incremental loading using Data Factory
  • Establish dimensions and facts
  • Create Dim 1
  • Create Dim 2…….
  • Create Power BI Data Flows
  • Create Top level report by Month of Customer Satisfaction containing last 12 months
  • Create KPIs for Satisfaction against this time last year
  • Drill through to detailed report
  • Drill through to lowest level

Bug

a Bug is an error in the code

  • Incremental Refresh is causing Duplicates
  • NULL data Items in Survey Data set

Issue

An issue is more related to a process, when the System fails to meet user expectation

  • Created a report based on poorly Served Customers but this needs changing to the new business logic.

Test Case

Test cases can validate individual parts of your code. We will look at this item in another blog post

Boards

Lets start with boards. These boards are Kanban Boards

A Kanban board is one of the tools that can be used to implement Kanban to manage work at a personal or organizational level.

When the board is first opened up, Epics don’t seem to be available

With Boards Selected Go to Configure Team Settings

Make sure that Epics are ticked in Under Backlogs

And now with Epics selected click on New Items are start adding in the required Epics

Next we need to start adding some features. It would seem that you cant add the features and then connect them to the epics. You have to create the Features from the epics

go back to the epic, click on … and Add Feature

And you can then see the feature within the Epic

Now we have a Feature we can add the user Story. Go to Features and click on the Add User Story

Same again. Move to User Stories and add Tasks

You can also go into the items and add lots more detail

This link to the Microsoft Documentation gives you lots of information regarding, effort, story points, business value, Priority etc.

Its always good to create the epic and work your way down into the Tasks

Retrospective Items

For this example, items are being added for a sprint that was closed some time ago because the project is being retrospectively moved into Azure Boards

Epics

I am starting them all from the beginning of this particular Project and for this I can add a Start Date

Stories

The Start Date also Applies to Stories but these will be set when the stories were originally created

However when you close a task and move the whole story into completed, you cant set a completed date


If you click on History and look at the state graph, you cant change the New and Resolved Times. These are set at the time of the action which makes it difficult to add past information into the Board

Backlogs

  • Backlogs help you to Quickly define work (User Stories, backlog items, requirements)
  • You can reorder the backlog so you work on the highest priority first
  • Add details and estimates
  • Assign items to team members and sprints by either bulk update or drag and drop
  • Map items within a hierarcy
  • Review the portfolio of work
  • Forecase work to estimate deliveries
  • Display rollup progress, counts and totals to show completion of work

Basically your backlog displays work items as lists and boards display them as cards

The Remaining Active User Stories have been dragged to Iteration 1

Work Items

All the work items you create can be viewed in here as well as created

Hopefully this gives you a little head start into the world of Azure DevOps boards

Power BI New Visuals Feb 2020 Release The Funnel and Pyramid chart by XViz

lets again have a look at the Adventureworks visuals using the Adventureworks warehouse as the sample data set

Funnel and Pyramid chart by XViz

Great for looking at Lead to Customer Conversion process for Sales analysis. Also great to visualise business functions like Organisation Hierarchies.

a very simple example is to look at Sales by Education

Its very possible that those actually in a College activity are providing us with the most revenue (Partial College)

YTD Internet Sales was change to Show value as Percent of Grand Total and in Format. Labels were turned on.

You can also change it into a Pyramid

as an example, the sales team have their own data of Prospective Buyers and the code changes when they convert to actual customers.

In Power Query Editor, a New Column has been added to track conversions

A custom column was also added and set to 1 for an easy customer count.

We only have 4% of customers as leads at the moment. Over 51% have converted to Large Scale Projects with us.

1 % have had one call from us so the Sales team need to get more leads and make more calls.

Click on the report Advanced Editor

And you can add Conditional Formatting.

However, there seems to be an issue here because, we have 6 in the range but the colours only come out in three groups which isn’t correct

Power BI March 2020 New Drill through Functionality

Currently we have lots of visuals on the report pages and the only way to know that they drill through to other reports is to hover over them

In the March 2020 release there is new functionality in the form of buttons

Add a blank button

This button is now set to drill through preview and you have chosen the drill through page. On normal drill through, everything this that is available is shown which is difficult when the report structure is complex. This allows you to target and manage the drill through structure.


Nothing selected
31 days selected

And this drills through to the detail reports for 31 days. Note that the tooltip in Desktop tells you how to drill through. Lets see this in Service.

Change the text on the button

Lets customise the button text using conditional formatting

the data item behind this drill through is ‘Resolved in’ and then it contains number of days categories.

Create a new measure

A new measure has been added to the dimension table containing the Resolved in Item

String for Resolved in Button logic = IF((SELECTEDVALUE('dim table'[Resolved in ],0)==0),"See Resolved in Details", "See Details for " & SELECTEDVALUE('dim table'[Resolved in ]))

If the selected value is null, set it to 0. So if its zero, show “See resolved in Details”. If its not zero then it can be displayed

Add New Measure to the Button

Resolving a noisy drill through with Drill through Buttons

This visual in this Drill though report has three Drill through’s for Incident. Then the stage of the incident. Finally the Business Property Drill through. All are valid but we would prefer to Not have the stage here because this should only be accessible via Incident.

Add two buttons. Link one to the Incident Drill through report. The other to the Business Property Drill through report

We want the button to be dark red when its active.

Create a new measure for the Incident in the incident Dimension

String for Incident in Button logic = IF((SELECTEDVALUE('dim BPIncident'[Incident Ref],0)==0),"See Incident Details", "See Incident Details for " & SELECTEDVALUE('dim BPIncident'[Incident Ref]))

And add this as conditional Formatting to the button Text

Create a new measure in the Business Property Dimension

String for Business Property in Button logic = IF((SELECTEDVALUE('dim BusProperties'[BP Number],0)==0),"See Business Property Details", "See Business Property Details for " & SELECTEDVALUE('dim BusProperties'[BP Number]))

And add this as conditional Formatting to the button Text

And now you should get drill throughs that the user can immediately see and use. Avoiding the stage drill through because it doesnt match what we want the journey to be

Note that the buttons are greyed out

Weaknesses

  • The button takes up more space.
  • Currently you have the drill through button and the drill through on the visual. This could be confusing to the user. It would be great if you could turn the drill through on the visual to off

A Roundup of Cool new Power BI Visuals Pre January 2020 release

There have been so many awesome new visuals come out that we need to take a moment to have a look at a few using Adventureworks as the example data set.

Advanced Gauge by OKViz

Looking at Year to date and Last Year to Date Measures of Internet Sales and Quantity of Products Bought

We have some DAX to create the following measures for this year to date and Last Year Year to Date

YTD Internet Sales = TOTALYTD(SUM(FactInternetSales[SalesAmount]),DimDate[FullDateAlternateKey].[Date])
YTD Quantity = TOTALYTD(SUM(FactInternetSales[OrderQuantity]),DimDate[FullDateAlternateKey].[Date])
LY YTD Quantity = CALCULATE([YTD Quantity],SAMEPERIODLASTYEAR(DimDate[FullDateAlternateKey].[Date]))
LY YTD Internet Sales = CALCULATE([YTD Internet Sales],SAMEPERIODLASTYEAR(DimDate[FullDateAlternateKey].[Date]))

These would look great in a KPI or two gauges. However, the Advanced Gauge allows you to view them together

Download the visual from the market place.

First of all I’m going to add a Filter for year to the report

The Actual and Target Values for your primary measure is the outer ring and your secondary measures for quantity make up the central ring

You could also add Minimum and Maximum measures if you had them.

This is a really nice visual but at a glance, without the table info it can be quite hard to read and I find the tooltips a little confusing

Once you get a handle on it its clear that we sold more in 2012 than 2011 but we made less money

Straight away, that leaves you wanting to set up analytics to find out why that happened.

Some of the reviews of this visual say it doesn’t work with percentages though which is disappointing

XViz Hierarchy Tree

This is another custom visual to show off your hierarchies

This is very similar to the decomposition tree which is maybe preferable in terms of look and usability. You cant choose the next step down in the tree like you can with the decomposition tree for example

You need ALOT of space for this one

There is already a nice hierarchy for Location data set up. Add Product category to this and analyse by Sales Amount

We are interested in the 20 items against North America so I can click on the end of the node to find out more.

You can see why you need space for this one. There is a bar to allow you to move in and out but its quite hard to control where your visual will end up on the page. I couldn’t get it looking any better than the above visual.

Still, Users will love this because it gives them the ability to interact with the data. Would I choose this over the decomposition tree? Probably not.

It doesn’t look to good when you bring the visual down to size. You would need a full page for this one

X Viz Hierarchical Filter

This visual is a similar one to an old hierarchical filter

This is the new version

And this is the old version

The findings are that if you have multiple hierarchy items in the new version, this visual takes up much more room than the original Hierarchy filter. The preferred choice may be the original one for taking up less space on a page.

And don’t forget, Hierarchical filtering is now available on the Slicer visual that comes with power BI

XViz Bullet Chart

This bullet chart was developed as a replacement for gauges and meters. It saves space and can be either horizontal or vertical.

We have three measures I want to look at by Product Sub Category and I want to be able to slice by Product Category so I can see, for example all the Bikes

YTD Revenue = TOTALYTD(SUM(FactResellerSalesXL_CCI[Sales Amount]),DimDate[FullDateAlternateKey].[Date])
LY YTD Revenue = CALCULATE([YTD Sales],SAMEPERIODLASTYEAR(DimDate[FullDateAlternateKey].[Date]))
2 Years ago YTD Revenue = CALCULATE([YTD Sales],PARALLELPERIOD(DimDate[FullDateAlternateKey].[Date],-24,MONTH))

We wanted to add Year to date for the same period two years ago and for this the PARALLELPRERIOD function can be used. In this case, its looking at 24 months previous to the Date.

Bands have been set within the format, rather than using data

Straight away we can see Jerseys are producing high sales and last year there seemed to be a dip in sales. We are doing much better in the current year

X VIZ Parallel Coordinates

this visual allows you to compare series on a set of numeric variables

Using the previous visuals measures as an example

This immediately shows us that there are 6 product categories leading the way and we are doing much better in the current year than in the last two years.


This visual tells us that we are selling more road frames than road bikes, however we make a lot more money with Road bikes

XVIZ GANTT Chart

In one of our Reporting projects we have a GANTT Chart by MAQ Software

This gives a really nice timeline overview of incidents per location and what the impact is, along with the stage of the incident. This has already been well received, so the question is, how will XVIZ GANTT chart compare?

The MAQ Software visualisation was created by the following fields

Essentially, the MAQ GANTT chart has been re-purposed here for something other than tracking of a project. A brief look at the XVIZ GANTT chart and it would seem like you use it specifically for project tracking.

Therefore you need data items like;

AssignedTo, CompletedDateTime, CreatedDateTime, DueDateTime, PercentCompleted, StartDateTime, TaskName, TaskStatus,TaskOwner etc.

This looks good and if you want to track projects within Power BI over the top of a data source this may be the way to go. However we use Azure DevOps Boards or Jira. the MAQ Software GANTT Chart gives you more options to use the visual for other reasons which is a really good reason to add it to your reports.

Zebra BI Charts

These are really great looking reports. As soon as you try and add any more detail like Category into Group, which would split you report into reports by Group

Annoyingly, you get pointed towards a free trial but I cant find anywhere that openly states what the costs are. Its not even mentioned in the frequently asked questions.

Personally, if there is a cost attached I like the company to be more open about it. Therefore I’m not comfortable with trying the free try. this is a shame and I think Zebra should state the costs before the trial.

Market Place visuals are created by External companies. Always check with your organisational policies that you are happy to use these visuals

Power BI 2020 Updates Incremental Processing for Power BI Pro from (Source) Azure SQL Database (Bug)

This is really the most exciting update for probably all of us working with Power BI. Currently we already have a backlog or reports in Pro that have required Incremental loading for some time so its great to be able to finally get the chance to try it

Our Project, to view Tweets with sentiments etc in a Power BI Report involves the following Services:

Logic Apps

A Logic app that is triggered when a new tweet is posted regarding a specific company

Content Moderator – Logic Apps uses the content moderator to check for profanity

Cognitive Services – Logic apps uses the Cognitive Service to add a sentiment score and to find key phrases

There is also a second Logic App that uses the same logic for Tweets posted by the company.

Azure Storage Account – Tabular Data Storage

  • The Logic Apps loads the tweet information into a Tweets Table
  • The Keyphrases into a Keyphrases table that connects to the tweets table
  • The Media items into a Media table that connects to the tweets table

Data Factory

Data Factory is used to load the information from the Tabular Data Storage into a SQL Server Data base staging area incrementally

The logic is fairly straight forward in that data items are inserted. Nothing is updated or deleted

There is a Pipeline for each single table

The SQL For the Lookup for the data set Mentions

SELECT MAX(WatermarkValue) AS WatermarkValue From [staging].[watermarktable]
WHERE WatermarkValue IS NOT NULL
AND TableName = 'staging.mentions'

the Watermark is a table in SQL that is updated with the Max Date at the end of the process

The query for the Source

CreatedAt gt '@{activity('LookupWatermarkOld').output.firstRow.WaterMarkValue}'

Basically brings through records greater that the value in the lookup table

I have a pipeline over each separate pipeline to run them all sequentially

Next comes a pipeline to run all the stored Procedures to move data from staging to dims and facts in SQL

At the end of these stored procedures we move the date on to the max date in the watermark table (And at the beginning in case there is an error in the SQL pipeline)

Doing this means that Data Factory only loads new records and doesn’t have to reload the staging area ever time

The Top level pipeline runs all the incremental Copy pipelines and then the Stored Procedures

Lets have a look at our watermark table before and then after a load

And a look at our last import of tweets in the audit table.

There are more audit tables to help find any issues. This is after the run on the 13th March (Test 2)

Data Factory Trigger

Because its not in full use at the moment the data set is loaded once a week on a Sunday at 12:50 and until this is being retested its being set to off

Azure SQL Database

In here we have the Watermark Table. All the audit tables, the staging tables and dimensions and facsts

the Fact and Dimensions are currently created via Stored procedures but the hope is to try and change to data flows.

Power BI

the Data is imported into Power BI Pro (Full Process) so the model is dropped and recreated.

Azure Data Studio

Is there any way we can have a look at what is going on when we load. Yes, by using Azure Data Studio

https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15

Once installed, connect to the SQL Database that is your data source

So long as you have the profiler extention installed you can Launch Profiler

If you don’t have it, you can download the extension

Once Launched Start a Profiler Session

Now we need sometime to Profile. go into Power BI service, Datasets.


click on refresh now and then go to data Studio to see whats happening

From Logon to Logout during the run, it took 20 minutes because the entire model is refreshed. obviously it would be really good if we could get the time down using incremental refresh

Before you set up Incremental processing, ensure that the services preceding the Power BI Load have been well tested and signed off.

Incremental Processing in Power BI Pro

In Power BI desktop. Incremental refresh is now out of preview so no need to go to Options and Settings to turn it on anymore.

Define your Incremental refresh policy

If the system are acting as they should and there are no bugs or issues

  • New rows are added into the data set
  • No historical data is updated or deleted
  • Incremental loading can be added to every table apart from media tables because there are that many records. they can be left as full upload

Set up incremental refresh in Desktop. Create Parameters

It isn’t practical to hold all your data when you are working in desktop if you are working with a Large model.

Go to Power Query Editor

Select Manage Parameters

The two parameters that need setting up for incremental loading are RangeStart, RangeEnd

These are pre defined parameter names only available in Premium for Incremental processing

Range Start and Range End are set in the background when you run power BI. They partition the data

You need to be aware of Query folding here. This is when, you write lots of steps in M Query to transform the data and where possible they are applied at source. So RangeStart and RangeEnd will be pushed to the source system. Its not recommended to run incremental processing on data sources that cant query fold (flat files, web feeds) You do get a warning message if you cant fold the query

The suggested values are simply ones you add that get amended later during processing.

this start date was chosen because at present, the data only started to get collected in 2019 so there is only around a year of data

Filter the data in the model

Still in Power Query Editor, all the tables that require incremental load need to have the rangeStart and RangeEnd paramters adding to the filtered date column

Incremental refresh isn’t designed to support cases where the filtered date column is updated in the source system.

With this in mind, imagine you have a sales table with an Orderdate and an UpdateDate. the OrderDate is static. The UpdateDate will be updated if there are any changes to the record.

Order date would need to be chosen as its static, so lets go through the tweet tables and set the filters. Click on the Column header icon to get to the filters

In power BI you don’t need so much data to do the testing, so this is great to keep the data smaller in desktop. At the moment, its using the default settings we provided.

  • dim.mentionsKeyphrases Twittertimestamp
  • dim. mentionsTweet CreatedAtDateTime
  • dim.BusinessKeyphrases TwitterTimeStamp2
  • dim.BusinessTweets CreatedAt
  • dim.BusinessReplies CreatedAt
  • fact.Mentions Date (For this, date was created from the date time Key in Power BI Query Editor)

Close and Apply

Define your Incremental Refresh Policy in Power BI Pro

go to your first table and choose incremental refresh

Storing everything  for 5 years. its set to months so the partitions are smaller

If this is running every single day then you would only need to refresh rows in the last 1 day. However as a just in case 1 month has been used, in case for any reason the job is suspended or doesnt run.

Detect Data Changes has been used. The months data will only be refreshed if the ImportDate for this record is changed (Or there are new records)

No records are deleted so we don’t need to worry about this

Publish the new Power BI Report and Data Flow

You might be thinking at this point, but I dont want the filters that I have set for Desktop to be applied in Service. I want to see all my data in Service

Dont worry, in Service RangeStart and RangeEnd don’t keep the dates specified for the filters in Desktop.

they are set via your incremental refresh policy. So they are set as the partitions for our 60 months (Instead of setting it to 5 years, meaning there is one RangeStart and OneRangeEnd, you get RangeStart for Month one, RangeEnd for Month 1, RangeStart for Month2, RangeEnd for Month2 etc, breaking your 5 years down into much smaller partitions to work with,

You need to set up the Incremental Refresh policy for every table that has been filtered with RangeStart and RangeEnd

Test the Process

I have a visual for Number of Tweets

Today so far there are 11 Tweets

I also have an audit report

  1. The Logic App has been processing tweets realtime into Table Storage
  2. Run Data Factory (2 new records)
  3. Reprocess Power BI Pro data Error Resource name and Location need to match
  4. If there hadn’t been an error we would move to Azure Data Studio Check. Note that it now takes a second to run
  5. Check the Visual

Error Resource name and Location need to match

The data set now has a warning sign. after speaking to Microsoft this is a Known issue and should be fixed in April. it is believed to be something to do with detect Data Changes So basically…… to be continued

Power BI Switching Tenants and User Accounts (Emails) but can only see Dataflows from previous tenant

Recently we did a training course with two developers in our own tenant under two training accounts. the training was done on their own computers but they logged into our tenant with our training details.

Then they moved back to their own tenant in Power BI Pro with their own details to start creating a data flow.

They have an App workspace and are both Admins in the workspace

Developer 1 Created Workflows within this App Workspace.  Developer 1 can open these data flows but Developer 2 doesn’t have access because they are not the owner which seems like the correct logic. they should only be able to use them in Desktop.

However, when both Developer 1 and developer 2 both go into Power BI desktop and attempt to connect to the data flow (Both Desktop and Service is connected to the company account)  they see a dataflow that was created our tenant when we were doing the training course. the new data flows cant be seen by either Developer.

They have both tried to refresh the view (Above) but this didn’t work. This does seem to be something that happens with the users log out and use a different account in a different tenant

How to resolve the Issue

Use Files Options and settingsData source Settings

then find Power BI Dataflows in Global Permission, then Clear Permissions of it.

When you Connect to the Power BI Dataflows again you have to sign in. Sign in as the current user, then you can see the Dataflows of your current account.

So if ever you are working in more that one tenant, remember this fix if you can only see the dataflows from the previous account

Power BI 2020 Updates. Hierarchical Slicer

We currently have a report with a hidden slicer panel, and one of the slicers is for Date. We want the user to choose the month of the report

Click on the visual and you can see that its the Hierarchical slicer from the Market place

However, Power BI February 2020 updates includes this feature on the main slicer. Can we Change out hierarchical slicer to the original Slicer and see how it looks?

Options and Settings

Currently this is a preview feature and it needs to be turned on and Power BI re -started

Use Selection Pane to check where the original slicer is


The Slicer is currently in the Slicer Group on this specific Bookmark

Now, with the Slicer visual selected, simply click on the original slicer in Visuals to change the Visual


Lets see the difference

It looks great and there is no need to add an additional visual from the market place


I’ve set single select to ON so you can only choose one month

I think this looks like a great new update and one that clears extra visuals from your reports