Using Power BI Deployment Pipelines and curious what happens when the report and dataset are in different workspaces? How does it work when you promote to another pipeline? Kevin Arnold shows us! Kevin Arnold: https://twitter.com/kevarnold https://www.linkedin.com/in/kevarnold/
Ever struggled with trying to get a parameter to select all items by default in a Power BI Paginated report? Patrick walks you through how to get this working! Create parameters for paginated reports in the Power BI service https://docs.microsoft.com/power-bi/paginated-reports/paginated-reports-parameters
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
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
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 [...]
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
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 [...]
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
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/
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
