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/
About pleblancThis author has not yet filled in any details.
So far pleblanc has created 123 blog entries.
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/
Have you struggled to compare data from two different time periods in Power BI? Does the data just continue on and not overlap? Patrick shows you how you can easily overlay the data for comparison. Download sample
Take Power BI Conditional Drill to the next level by incorporating Paginated reports with your strategy! Patrick shows a customer scenario that he solved using this approach. Paginated reports doc: https://docs.microsoft.com/power-bi/paginated-reports/paginated-reports-report-builder-power-bi Power BI Report Builder: https://docs.microsoft.com/power-bi/paginated-reports/report-builder-power-bi Conditional Drill video using buttons - https://www.youtube.com/watch?v=4Qy-bksqExI
There are different interactions Power BI visuals can have, but how do we conditionally highlight a bar in a Power BI report using a slicer? Patrick shows you some MAGIC to get this to work. Question from Live Stream Phil Seamark's Blog Edit Interactions Documentation Conditional formatting Download Sample
The smart narrative visual can help tell the story in your Power BI report. Justyna Lucznik joins us to explore the visual and to illustrate how you can generate text about your data. Make sure you have the September 2020 version of Power BI Desktop, or later. Documentation: https://docs.microsoft.com/power-bi/visuals/power-bi-visualization-smart-narrative Connect with Justyna Lucznik on Twitter: [...]
Your Power BI report could be slow and not functional. Publishing to Power BI may also show you your ugly baby. Patrick has you covered with 5 things to do before publishing to get that cute baby! Power BI Tips: External tools (@PowerBITips) Splitting a Power BI (PBIX) File into a Dataset and Lean Report [...]