fbpx

How do THIN reports work with Power BI Deployment Pipelines?

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/

How do THIN reports work with Power BI Deployment Pipelines?2023-03-13T12:13:59-05:00

Select All items for Parameters in Power BI Paginated reports

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

Select All items for Parameters in Power BI Paginated reports2022-08-19T07:05:28-05:00

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
Go to Top