Maybe you've heard of Power Query M in Microsoft Excel, Power BI or something else. Do you really need to be an expert in that? Or even use it? Patrick helps to ease your mind!
About pleblancThis author has not yet filled in any details.
So far pleblanc has created 128 blog entries.
Not sure what Power BI Paginated Reports are or how to use them? Patrick walks you through and points you to some great resources to get up and running quickly. Power BI Paginated Reports require either Power BI Premium Per User or Power BI Premium capacity. References Paginated Report In a Day Training Paginated Samples [...]
Are your paginated reports still on-premises with either Power BI Report Server or SQL Server Reporting Services? Want to move them to Power BI? Patrick shows you how you can do that using the RDLMigration tool! Documentation: https://docs.microsoft.com/power-bi/guidance/migrate-ssrs-reports-to-power-bi RDLMigration Tool on GitHub https://github.com/microsoft/RdlMigration GitHub release page https://github.com/microsoft/RdlMigration/releases App Registration https://dev.powerbi.com/apps
Are you using Incremental Refresh in Power BI? Are you stuck with how to handle deletes? Patrick has a great technique you can use to not only handle deletes, but also more easily handle updates with your partitions. Download Sample
You may be able to write a DAX expression, but what about an actual DAX query? DAX queries can help you validate data and fine tune your DAX expressions used for Power BI. Patrick shows you how!
Have you noticed the updates Power BI dataflows has had recently? Patrick explores Visual Data Prep which helps you craft your transforms in Power Query Online. Blog: https://powerbi.microsoft.com/blog/announcing-visual-data-prep-public-preview-diagram-view-in-power-query/
Too many rows? How is that possible? Patrick looks at a case where a customer hit an error of too many rows coming back from a DAX statement in Power BI.
We've looked at images from sources like OneDrive and the web with your Power BI reports. What about from a database? Is that possible? Patrick takes a look at how you can do it. SQLJason Blog: http://sqljason.com/2018/01/embedding-images-in-power-bi-using-base64.html Gerhard's Blog: https://blog.gbrueckl.at/2018/01/storing-images-powerbi-analysis-services-data-models/ Chris Webb's Blog: https://blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets/
Are you curious about how images can be used in Power BI? Patrick looks at some different ways to incorporate images into your data model and Power BI Report!
Are you using DAX Studio with Power BI? Patrick shows you why you should consider using it when working with DAX for Power BI! DAX Studio: https://www.sqlbi.com/tools/dax-studio/