home.social
Sign in Create account

#pbix — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #pbix, aggregated by home.social.

  1. James Bartlett :terminal: @[email protected] ·

    I've been working on #PowerBits (a collection of #PowerShell scripts for #PowerBI 📊 #Admins) recently, and I just made a minor breakthrough. 💪😎👍

    One of the biggest missing features of the Power BI #RESTAPIs right now is the ability to export a #Dataset as a #PBIX file. Of course, you can export a #Report 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 #BareDataset), then the #RESTAPI can't help you. That Dataset can only be exported manually from the Power BI Service using a web browser. Yuck! 🤮

    To solve this problem:
    1. Find and select a target #BareDataset
    2. Upload a #BlankReport to the same #Workspace
    3. Re-bind the blank Report to the bare Dataset
    4. Export the blank Report as a PBIX file
    5. Delete the blank Report from the Workspace

    Step 1 Complete (mostly) 😅:
    github.com/JamesDBartlett3/Pow

    #powerbits #powershell #powerbi #admins #restapis #dataset
  2. James Bartlett :terminal: @[email protected] ·

    Hey #PowerBI peeps, I'll be on #ToolTalk with Artur König and @mthierba on Tuesday, March 21st.

    We'll be talking about a little #ExternalTool I wrote for #PowerBIDesktop called #PbiToolsWatchPS, which launches a #PowerShell window running #pbitools in #WatchMode on the current #pbix file. The purpose of this little tool is to minimize the effort and number of steps necessary to #commit changes to Power BI #reports and #datasets into a proper #VersionControl system like #GitHub, #AzureDevOps, etc.

    Please join us #LIVE on Tuesday, March 21st, give us your thoughts about the current state of #CICD and #DevOps / #DataOps for Power BI, and tell us about your favorite #ToolsOfTheTrade!

    RSVP for the #ToolTalk session on #LinkedIn here:
    lnkd.in/gzZSxf_f

    Download #pbitools here:
    pbi.tools

    Download #PbiToolsWatchPS here:
    github.com/JamesDBartlett3/Pow

    #powerbi #tooltalk #externaltool #powerbidesktop #pbitoolswatchps #powershell