fbpx

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

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

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

Exploring Streaming Dataflows in Power BI

Are you wanting to use streaming data? Patrick looks at Streaming Dataflows! A new way to integrate streaming data into your Power BI reports! Streaming dataflows (preview) https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-streaming

Exploring Streaming Dataflows in Power BI2021-12-28T09:49:30-05:00

Power BI XMLA Endpoint: Why you should care

The XMLA Endpoint in Power BI can be very powerful. Adam looks at what it is and how to get started with it. If you are using Power BI Premium or Premium Per User, you need to know about this! Live Stream Question: https://youtu.be/_SLFZiA3peU?t=1229 XMLA Endpoint Documentation: https://docs.microsoft.com/power-bi/admin/service-premium-connect-tools Troubleshooting XMLA Connectivity: https://docs.microsoft.com/power-bi/admin/troubleshoot-xmla-endpoint Refreshing a single [...]

Power BI XMLA Endpoint: Why you should care2021-09-09T05:15:29-05:00

Can you refresh a single table in Power BI?

Frustrated that a you can only do a full refresh? Patrick takes it to the next level by showing how you can refresh only a single table in your Power BI dataset. This is a great option for targeted refresh and avoid potential overhead. Processing Options: https://docs.microsoft.com/analysis-services/multidimensional-models/processing-options-and-settings-analysis-services?view=asallproducts-allversions Refresh Types: https://docs.microsoft.com/azure/analysis-services/analysis-services-async-refresh Elegant BI Blog: https://www.elegantbi.com/post/datarefreshintabulareditor https://www.elegantbi.com/post/processingmanager

Can you refresh a single table in Power BI?2021-08-18T07:10:04-05:00
Go to Top