BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
There are a few good changes to Power BI Desktop this month, including a better icon and splash screen, on-canvas help (albeit pitched at too low a level) and the ability to let users tweak visuals you've published.
- October 2020 update of Power BI Desktop
- A new (and better) start-up procedure
- On-screen help (canvas watermarks)
- Personalising visuals
- Better recognition of Excel and JSON tables (this blog)
- Exporting data from a Q and A visual
Posted by Andy Brown on 22 October 2020
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Better recognition of Excel and JSON tables
Suppose you want to load this Excel table of data:
A simple table containing the names of supermarkets in the UK.
Previously you had 3 options:
- Get rid of the blank rows and columns to position the data at the top left of the worksheet.
- Turn the data into an Excel table (in which case Power BI would detect this on load).
- Use Query Editor to skip the blank rows at the top of the worksheet and delete the blank columns.
In the latest update of Power BI, you will now see this:
Power BI automatically starts at the top left of the data.
This is good, but it's not perfect. For example, here's another worksheet, this time containing two tables:
It would be nice if Power BI could load these two tables.
Here's what you get if you try loading this:
Sadly, Power BI can't distinguish between the two tables.
The new version also promises to automatically flatten JSON files into tables on load (previously users had to flatten records/lists manually). You need to enable this feature in Power BI settings to use it. I've never loaded a JSON file into Power BI, so can't throw any more light on this!