fbpx

Exploring the preview of datamart in Power BI!

We take a look at the newly announced preview of datamart in Power BI! A no code experience to build a relational database for analytics right inside Power BI! Announcement Blog: https://powerbi.microsoft.com/blog/announcing-public-preview-of-datamart-in-power-bi/ Documentation: https://docs.microsoft.com/power-bi/transform-model/datamarts/datamarts-overview

Exploring the preview of datamart in Power BI!2022-05-25T06:19:14-05:00

Demystifying Custom Partitions in Power BI

We talk about Incremental Refresh a lot, but what if you need custom partitions in Power BI? How do you even create those? They look scary! Patrick takes the mystery away and walks you through how you can create them. Partitions in tabular models https://docs.microsoft.com/analysis-services/tabular-models/partitions-ssas-tabular

Demystifying Custom Partitions in Power BI2022-04-21T07:10:14-05:00

Are you backing up your Power BI Dataset???

While Power BI is a SaaS service, backing up your dataset is still important. What if something was accidently deleted? How do you recover it? Patrick shows you how you can get a backup / restore process in place so you can sleep at night. Backup/Restore PowerShell Script: https://guyinacu.be/backuprestorescript Backup and restore datasets with Power [...]

Are you backing up your Power BI Dataset???2022-04-13T06:50:37-05:00

So, we just wait???

What's up with the wait time in Power BI Dataflows? Do we just live with it? What's going on and what can we do about? Adam, has you covered! Understanding and optimizing dataflows refresh https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-understand-optimize-refresh

So, we just wait???2022-03-16T07:28:33-05:00

Create Hybrid Tables with Tabular Editor for Power BI? YES!!!

Hybrid Tables are an incredibly powerful feature in Power BI. But what if you wanted to create them outside of Power BI Desktop? Patrick shows you how you can do just that in Tabular Editor! --This Year let Source = Sql.Databases("servername"), AdventureWorksDW = Source{[Name="databasename"]}[Data], internetsales = AdventureWorksDW{[Schema="dbo",Item="pbi_InternetSales"]}[Data], thisyear = Table.SelectRows(internetsales, each Date.IsInCurrentYear([OrderDate])) in thisyear --Last [...]

Create Hybrid Tables with Tabular Editor for Power BI? YES!!!2022-03-02T08:30:35-05:00

Do we need more Power BI Premium Capacity?

Capacity planning for Power BI Premium is not an exact science. How much capacity do you need? As with most things, it depends! Adam walks through some things to consider when thinking about your planning. Premium Gen2 capacity load evaluation https://docs.microsoft.com/power-bi/admin/service-premium-concepts Use the Gen2 metrics app https://docs.microsoft.com/power-bi/admin/service-premium-gen2-metrics-app

Do we need more Power BI Premium Capacity?2022-02-17T08:13:19-05:00

Is a parameter filtered in Power BI Paginated Reports???

How do you know if a parameter was filtered in your Power BI Paginated Reports? Was a slicer used in the Power BI report that is using the Paginated visual? Adam shows you a way you can find out! Create and use the paginated report visual https://docs.microsoft.com/power-bi/visuals/paginated-report-visual ISFILTERED Reference https://dax.guide/isfiltered/ ALLSELECTED Reference https://dax.guide/allselected/

Is a parameter filtered in Power BI Paginated Reports???2022-02-03T08:59:38-05:00

Create a date range parameter with Power BI Paginated Reports

How do you do a date range with the Paginated visual used with Power BI Paginated Reports? Adam shows you how to get a date range going without passing every day's value within the range. Create and use the paginated report visual https://docs.microsoft.com/power-bi/visuals/paginated-report-visual

Create a date range parameter with Power BI Paginated Reports2022-01-27T08:53:55-05:00

How Parameters work with the Power BI Paginated Visual

Parameters for the Power BI Paginated visual can give you a lot of flexibility. Adam walks you through how to set up the parameters and breaks down what is actually happening with the values. Create and use the paginated report visual https://docs.microsoft.com/power-bi/visuals/paginated-report-visual

How Parameters work with the Power BI Paginated Visual2022-01-26T07:14:40-05:00

Power BI Premium Gen2 updates (January 2022)

There are some updates for Power BI Premium Gen2 you should know about! Adam talks about the upcoming migration date and more! Are you ready for Gen2? Plan your transition to Power BI Premium Gen2 https://docs.microsoft.com/power-bi/admin/service-premium-transition-gen1-to-gen2 Install the Gen2 metrics app https://docs.microsoft.com/power-bi/admin/service-premium-install-gen2-app Use the Gen2 metrics app https://docs.microsoft.com/power-bi/admin/service-premium-gen2-metrics-app

Power BI Premium Gen2 updates (January 2022)2022-01-19T07:45:40-05:00
Go to Top