James Bartlett :terminal:<p>I've been working on <a href="https://techhub.social/tags/PowerBits" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PowerBits</span></a> (a collection of <a href="https://techhub.social/tags/PowerShell" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PowerShell</span></a> scripts for <a href="https://techhub.social/tags/PowerBI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PowerBI</span></a> 📊 <a href="https://techhub.social/tags/Admins" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Admins</span></a>) recently, and I just made a minor breakthrough. 💪😎👍</p><p>One of the biggest missing features of the Power BI <a href="https://techhub.social/tags/RESTAPIs" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RESTAPIs</span></a> right now is the ability to export a <a href="https://techhub.social/tags/Dataset" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Dataset</span></a> as a <a href="https://techhub.social/tags/PBIX" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PBIX</span></a> file. Of course, you can export a <a href="https://techhub.social/tags/Report" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Report</span></a> as a PBIX file, and if that Report is bound to a Dataset, then the Dataset will be included with the Report when you export it. However, if the Dataset you need to export doesn't have a Report bound to it (I've started calling this a <a href="https://techhub.social/tags/BareDataset" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>BareDataset</span></a>), then the <a href="https://techhub.social/tags/RESTAPI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RESTAPI</span></a> can't help you. That Dataset can only be exported manually from the Power BI Service using a web browser. Yuck! 🤮</p><p>To solve this problem:<br>1. Find and select a target <a href="https://techhub.social/tags/BareDataset" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>BareDataset</span></a><br>2. Upload a <a href="https://techhub.social/tags/BlankReport" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>BlankReport</span></a> to the same <a href="https://techhub.social/tags/Workspace" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Workspace</span></a><br>3. Re-bind the blank Report to the bare Dataset<br>4. Export the blank Report as a PBIX file<br>5. Delete the blank Report from the Workspace</p><p>Step 1 Complete (mostly) 😅:<br><a href="https://github.com/JamesDBartlett3/PowerBits/blob/main/PowerShell/Get-PowerBIBareDatasetsFromWorkspaces.ps1" rel="nofollow noopener noreferrer" target="_blank"><span class="invisible">https://</span><span class="ellipsis">github.com/JamesDBartlett3/Pow</span><span class="invisible">erBits/blob/main/PowerShell/Get-PowerBIBareDatasetsFromWorkspaces.ps1</span></a></p>