Power Query for Power BI Report Builder (Paginated Reports)

In this video the instructor guides viewers on how to incorporate Power Query into their Paginated Reports. The video covers the basics of Power Query, including how to transform data with various transformations, combining multiple data sources, and filtering data. The instructor also demonstrates how to use Power Query to connect to Fabric and OneDrive to import data into your report.

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

Let's connect:


Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
#PragmaticWorks #powerbi #powerquery

00:00 Intro
05:48 Importing Data from CSV and Lakehouse
19:38 Creating a Unified Dataset
30:09 Conclusion

[sergiizelenko]

If I had only seen your video earlier..., super useful! Thank you very much!
Btw, it seems that the issue with Privacy level hasn't been resolved yet. So combining data from different data soruces still remains impossible for Paginated Reports

[cleo]

Do you have a video going over Lakehouses like the one you presented in this video?

[celsomosquera]

Thanks for posting this and especially for disclosing the fact that this preview feature is not yet usable when you try to actually render the report due to PowerBI privacy level controls which are unavailable yet. This will be great when it works with semantic models natively and not obligating you to connect using the XMLA SSAS endpoint. Would be great to see your example including passing parameters and multi-valued parameters when that actually works. Thanks for your efforts!

[uahnbu]

Can I refer to a different Dataset, aka another query, in the Power Query Editor, cos one dataset can only hold one query?