I put together a Power BI report that pulls the sessions list from PASS Summit's web site. Here is the live report: You can find the report here as well in case the above embedding does not work. Power BI, PowerShell , and PowerApps Sessions I am mostly interested in Power BI, PowerShell, and PowerApps … Continue reading PASS Summit 2020 Sessions
PASS Summit 2020
With PASS Summit being virtual this year, one of the first questions I had was whether the event was going to be able to offer more than just technical sessions. While I have benefited from the technical sessions in the past, the most valuable aspect of the conference for me, has been the other parts … Continue reading PASS Summit 2020
Use PowerShell to download all your Power BI reports from a workspace
You can use PowerShell to download all of your PBI reports in a workspace all at once without having to go through the PBI service UI one at a time. As an added bonus, you may notice that downloading a report with PowerShell is faster that downloading it through the PBI Service UI. This script … Continue reading Use PowerShell to download all your Power BI reports from a workspace
How much can you save by splitting Date Time columns into separate Date and Time columns in Power BI models?
As you may have already heard, one of the easiest ways to reduce a Power BI model (dataset) size is by splitting DateTime columns into separate Date and Time columns but the question is how much space reduction can you achieve by doing so. As I show in this blog post, the reduction can be … Continue reading How much can you save by splitting Date Time columns into separate Date and Time columns in Power BI models?
How to kill idle SSAS sessions and connections in a batch
While connections and sessions don't take much memory compared to what the actual SSAS data does, they still take some memory that can be valuable to free up if a server is under resource pressure. SSAS routinely checks the amount of time elapsed from a session/connection's last command and if it has been idle for … Continue reading How to kill idle SSAS sessions and connections in a batch
I will be speaking at Light Up Virtual Conference
Proud and honored to be part of this great event by @CSharpCorner.Join for 24 hours of free learning and to help raise funds to fight COVID-19 in support of @UNICEF. My "Aggregations in Power BI" session is at 10-11 pm EST #PowerBI https://www.2020twenty.net/lightup/
I will be speaking on Aggregations in Power BI for the Irish Community Cafe / Dublin Power BI User Group
I am excited to be presenting on 06/22/20 at 9 am EDT for on the topic of using aggregations in Power BI. Meetup info for Dublin Power BI User Group and session details are below. #PowerBI #PBIUG https://www.meetup.com/DublinPUG/events/270402348/ Accompanying older blog post here: https://shabnamwatson.com/2019/11/21/aggregations-in-power-bi/ aggregations_in_powerbi_shabnam-watson_06232020-1Download
I will be speaking at #DataWeekender on Saturday May 2nd.
I will be presenting "Using Power Apps in Power BI reports: Enabling writeback". Join me to learn how to build a simple Power Apps app that can be integrated into a Power BI report to update data and have it refresh the Power BI report automatically after the data updates to reflect the changes. Register … Continue reading I will be speaking at #DataWeekender on Saturday May 2nd.
Slides from my presentation for PASS Women In Technology Virtual Group – 04-16-2020
Here are the slides from my presentation on "Using Power Apps in Power BI reports: Enabling writeback": using-power-apps-in-power-bi-reports-pass-wit-04162020Download Check out my previous post for step by step instructions and demo material. Here is the link to the session recording: https://www.youtube.com/watch?time_continue=1050&v=UbiwcRLnuM8&feature=emb_logo
Using Power Apps in Power BI reports: Enabling writeback
Post about how to add a simple Power Apps app to a Power BI report to update the report's data and refresh the page automatically.