You may create a report you wish to share outside of your organization on the Internet. Today, I’ll take a look at the steps to publish your report to the Internet so that the report has all of the same interactivity as the report you created with Power BI Desktop and published within your organization on the Power BI Service.

edit: This article was written on February 29, 2020. All elements contained within are subject to change with the current monthly release cycle the Power BI team is following.

edit: Make sure you only publish information to the Internet that you have cleared through proper channels within your organization.

Publish From Power BI Desktop To Power BI Service.

You cannot publish directly from Power BI Desktop to the Internet (web). You first must publish from Power BI Desktop to Power BI Service. Go back and check this post if you need a refresher how to publish from Power BI Desktop to Power BI Service.

Open The Report In Power BI Service

Log into the Power BI Service, navigate to your workspace, and open the report you wish to publish to the web. Here, I have a screen shot of the Filled Map Report I have been working with in my last few posts. This shows the population change by state from 2010 to 2019 where a darker color indicates a greater percentage change, while a lighter color indicates a smaller or even negative increase.

File Menu…Publish To Web

In Power BI Service, click on the File Menu. From the File Menu drop-down, click on Publish to web

Create Embed Code

You will receive a dialog window to create an embed code…click the button “Create embed code”

Next, you will receive a warning that you are publishing a report on the Internet that anyone can see. If you are sure you want to proceed, click on the button “Publish”

Generate HTML Code

After you click the Publish Button, you should receive the Dialog Window below indicating that everything was successful and you now have the html code you need to embed the report into a blog or website. You also have a link you can send in an email or paste into a browser to see what the report looks like

Here, I just pasted the link in a browser to see what it looks like:

The Embedded Report

Without further ado, here is the report, embedded in this blog, no more screen shots. This report is live. If I make any changes to the report in Power Bi Service, the change will also be captured here. You may use your mouse scroll wheel to zoom in/out on the map. You can hover on a state with your mouse to see the tooltip for each state. If you do not have this functionality, it is because you have enabled many security extensions on your browser that are blocking the correct functionality of the map. Try another browser such as Microsoft Edge

Admin/Tenant Settings

If you cannot publish your report to the web, it is because your admin for your organization has disabled Publish to web. Ask your admin to enable this feature.

Tidy Up

That’s it for today. Stay tuned for whatever is next….wit? rancor? rant? sarcasm? bramble?…most likely the latter

, , , , ,

Today, I’ll take a look at the process to publish a report from Power BI Desktop to Power BI Service so you can share your reports within your organization.

Power BI Desktop Version

I’m using version 2.78.5…. released ~ 2/8/2019. If you are using a different version, your results may vary.

Power BI Desktop Report To Publish

Open the report you want to publish to your workspace on the Power BI Service. Here I have a Filled Map based on population change by state from 2010 to 2019. Go back to this post if you need to review how to create the Filled Map.

Click To Publish

Click on the publish icon in the Share Group on the Home Ribbon in Power BI Desktop.

Sign Into the Power BI Service

If you are not already signed into the Power BI Service, you will be prompted to sign in. Enter your email address

and your password

Select Workspace

Once you successfully log into the Power BI Service, you will be prompted to choose a workspace to publish the report to

Replacing Dataset

If you already have a report with the same name already published to the workspace, you will receive a warning that you are about to replace the original with the new – be careful if that is not what you intend to do.

Publishing…Success

You should receive a message that the report was successfully published to the Power BI Service.

Power BI Service

Next, I’ll check that the report is indeed published to my workspace in the Power BI Service. I need to log into my Power BI account – powerbi.microsoft.com

and password:

Navigate To The Workspace

Navigate to the workspace you published your Desktop Report to. I published to “My workspace”, so I’ll select that.

After you navigate to your workspace, click on the Reports Menu at top

In the list of reports, find the report you published from Power BI Desktop

Check the report to make sure it looks just the report you created in Power BI Desktop. I tried Firefox and Chrome Browsers and the Conditional Formatting did not render correctly. Most likely because I have several extensions enabled for both of those browsers. I then tried to open the report in the Microsoft Edge Browser where the report rendered as expected with the correct conditional formatting.

Tidy Up

That’s it for today. In the next post in this series, I’ll see if I can publish to a public web page so that the report is live and interactive.

, , , , , ,

Well said by Jim Rohn. Today, I’ll look at at how to format a filled map (Choropleth) in Power BI.

Power BI Desktop Version

I’m using version 2.76.5…. released ~ 12/18/2019. There are no newer updates as of 2/15/2020. If you are using a different version, your results may vary.

Report Window

From the Data Window click on the Report icon on the left. This will stitch the view from the Data Window to the Report Window and expose the Visualization Pane

Create The Filled Map

Click on the Filled Map Visualization Icon in the Visualization Pane. The Filled Map Visualization will appear on the Report Canvas.

Click on the Filled Map on the Report Canvas. This will expose the Location Fields at the bottom of the Visualization Pane. Once the fields are exposed, drag the State Field from the Data Pane to Location. Lastly drag the Pcnt Change Field from the Data Pane to Tooltips in the Data Fieelds at the bottom of the Visualization Pane.

You should now have a filled map that looks something like the image below.

Conditional Formatting

Now I need to add divergent colors to the filled map so I can quickly see which states have the greatest percentage change in population from 2010 to 2019.

  1. Click on the Filled Map on the Report Canvas
  2. Click on the Format Button Below the Icons in the Visualization Pane
  3. Click on the drop-down for Data colors
  4. When you mouse over Default Color notice that a vertical elipses is visible
  5. Click on the vertical elipses
  6. Click on the fx Conditional Formatting pop-up

The Default Color – Data color dialog opens. The State is the default field for Based On Field – click on the drop-down and change to Pcnt Change.

Change the Colors for Minimum and Maximum to 2 different contrasting colors. I’ll use a very light grey and black.

Interpret the Visualization

Even at this small zoom level, it is easy to see some differences in population increases and decreases. It appears as though West Virginia, Illinois and Mississippi had negative to very low population increase. On the other hand; Nevada, Texas and Utah had large population increases.

The only one I found surprising was Utah at 16% increase from 2010 to 2019. I had heard of all of the others through social media and or news outlets over the past few years.

Divergent Color

You can add a 3rd color to the Conditional Formatting if you so choose. Tick the checkbox for Diverging and you will receive a middle value input for the middle color as well.

Custom Color – HEX Only, No RGB

I come from Excel where I am used to using RGB (Red, Green, Blue) values for creating custom colors. RGB is not an option in the Default Color Dialog – you have to use hexadecimal values.

Hexadecimal Resources

I found a good resource for working with hexadecimal colors at color-hex. Make sure you check it out.

Tidy up

That’s it for today. Grab the workbook from my OneDrive. Post inspired by this post at PowerBI tips by Mark Carlo and Seth Bauer.

, , , , , , , ,