There are two export options: Export to Template, and Export to PDF. Exporting to Template creates a very small file without embedding any of the data, but contains links/references to the data. This could be used to share dashboards with people that have access to the exact same data and data locations. When they open the template, it will build the dashboard, pull the data, and populate the visuals. It seems you cannot save files to this state as it opens as a new PBI doc. Trying to save it will save as a regular .pbix file.
You can export single pages to PDF from PBI by either deleting or hiding (right click > hide page) all the other pages. PBI currently does not have functionality to export one page by itself, nor a “hide/show all” function (As of June 2021). If you do not hide or delete other pages, it will export all of them into a PDF. Note that none of the visuals will be interactive once exported.
Tip: Nick has set up a basic AutoHotKey macro to automate deleting pages. Executable (shouldn’t require installing AHK to run) and source code (needs AHK installed to run) attached below*.
* Cannot upload to wordpress b/c of safety reasons so raw AHK code below instead
Tip: Save a duplicate copy of your report with all pages deleted, but data queries still connected. You can ctrl+A, copy, and paste individual pages for export here. Eliminates need to delete/hide/unhide pages over and over.
Note: Your level of zoom affects the export. This can be changed via the “Page view” option under the “View” tab on the menu ribbon. If your export is cropped or strangely cramped, try changing page view to Actual size.
; Thrown together by Nick To at some point in 2021 Q2 ¯\_(ツ)_/¯
#NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases.
; #Warn ; Enable warnings to assist with detecting common errors.
SendMode Input ; Recommended for new scripts due to its superior speed and reliability.
CoordMode, Mouse, Window
MsgBox, Make sure PBI is maximized on your main monitor (this script assumes your monitor is 1920x1080)`n`nHotkeys: `nAlt + Esc = Emergency stop/instant kill script`nAlt + Ctrl + s = Enable/disable hotkeys`nAlt + c = Start PBI page delete macro
; ! = alt
; ^ = ctrl
; + = shift
!Esc::ExitApp ; Emergency kill script key
!^r::Reload ; Reload script
!^s::Suspend ; Suspend script
; Delete PBI Sheets
; Have PBI maximized on main monitor (this script assumes your monitor is 1920x1080)
!c::
WinActivate, ahk_exe pbidesktop.exe
InputBox, count, , How many consecutive pages to delete? Will start from leftmost visible page.
MouseGetPos, xpos, ypos ; Saves current cursor position
Loop %count% {
Click Right, 89, 999 ; Deletes page furthest on the left
Sleep 250
Send {Down}
Sleep 100
Send {Down}
Sleep 100
Send {Enter}
Sleep 500
Send {Enter}
Sleep 1200
}
MouseMove, xpos, ypos ; Moves cursor back to original position
MsgBox Done, exiting
ExitApp
Return