Power BI Table Storage Modes and Model Types

I still get a lot of questions from various Power BI developers about table storage modes and how table storage modes affect an entire model’s type. Here is a post to summarize all table storage modes / model types. The following table storage options apply when creating a Power BI model. Table Storage ModeData Stays … Continue reading Power BI Table Storage Modes and Model Types

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

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

Aggregations and Time Series calculations in Power BI

I have received a couple of questions about Aggregations in Power BI and whether they can be used to cover time series calculations such as Year to Date, Quarter to Date, and Month To Date. The answer is yes. Since time series calculations break down into calculations over a series of days, an aggregation table … Continue reading Aggregations and Time Series calculations in Power BI

Connecting live from Power BI Desktop to SSAS generates this error: The Server you’re trying to connect to doesn’t have any models or you don’t have permissions to access them.

I recently ran into an error while connecting live from Power BI Desktop to a SSAS server. Everything was on-premises.There was no cloud component involved. I had full admin rights to the SSAS server and could see all databases and models from SSMS and other tools but was getting this error from PBI Desktop. The … Continue reading Connecting live from Power BI Desktop to SSAS generates this error: The Server you’re trying to connect to doesn’t have any models or you don’t have permissions to access them.