In this video, Patrick answers your question about how to do this in Analysis Services Tabular and Multidimensional. Also, he adds a little bit of SQL to the mix. Make sure to watch the previous dynamic filtering videos to understand the basics of how to do this. To begin, you need to make sure to [...]
In the first post in this series, I explained how to drill from a mobile report to a paginated report that contained parameters populated from a SQL Server database query. This was pretty simple and straightforward. What if the data in the parameter of the paginated report was populated from a SQL Server Analysis Services [...]
I met up with Peter Myers to talk about an upcoming EdX course for Analysis Services Tabular. He wrote and primarily presented the course which is free to you. You also have the option to upgrade to get a certificate of completion if you wish. The course will be released on March 14, 2017, and is [...]
Web.Contents(), Caching And The ExcludedFromCacheKey Option In Power BI And Power Query (@technitrain) Extract Tabular Data From Power BI Service to Excel (@ExceleratorBI) Power BI Desktop January Feature Summary Embedding a Power BI report into Salesforce Power BI mobile phone reports now available everywhere BONUS: Power BI Desktop – 2016 Year in Review Using Power [...]
Power BI – 12 Days of Dashboards (@SQLSamLester) New Combine Binaries Experience (@kpuls) What’s new for SQL Server vNext on Windows CTP 1.1 for Analysis Services Introducing a Modern Get Data Experience for SQL Server vNext on Windows CTP 1.1 for Analysis Services Power BI reports in SQL Server Reporting Services: Feedback on the Technical [...]
Use Cases for Azure Analysis Services (Part 2) (@SQLChick) http://www.sqlchick.com/entries/2016/11/29/use-cases-for-azure-analysis-services How to Combine System and Manual Data in a Power BI Data Model (@PowerBIPro) https://www.powerpivotpro.com/2016/11/combine-system-manual-data-power-bi-data-model/ Power BI mobile apps feature summary – November 2016 https://powerbi.microsoft.com/en-us/blog/power-bi-mobile-apps-feature-summary-november-2016/ Power BI Desktop November Feature Summary https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-feature-summary/ Announcing the Preview of Download Power BI Desktop files from the web https://powerbi.microsoft.com/en-us/blog/announcing-preview-of-download-power-bi-desktop-files-from-the-web/ [...]
Not Folding; the Black Hole of Power Query Performance (@Rad_Reza) Calling Microsoft Flow From Power Query And Power BI (@technitrain) Analysis Services Tabular Is (Finally) NUMA-Aware! (@SQLbyoBI) What’s new in SQL Server 2016 SP1 for Reporting Services What's New in SQL Server vNext BONUS: Excel Workbook Connection to Local Power BI Desktop (@ExceleratorBI) Grouping and [...]
e had a lot of announcements come out of PASS Summit 2016. Here is a recap of some of the big items. Here is the roundup for November 3, 2016. Power BI Desktop October Feature Summary Grouping and Binning; Step Towards Better Data Visualization Announcing a Technical Preview of Power BI reports in SQL Server [...]
There were a bunch of items I found this week. From tips for beginners, to some gateway updates and items for Analysis Services. I have a few bonus links down below that weren't included in the video. Top 10 Tips for Getting Started with Power BI (@ExceleratorBI) Translations in Analysis Services 2016 (@marcorus) On-Premises Data [...]
This week we have some items for Analysis Services, some Power BI tips and a mobile update. SSAS Tabular Model Development Using Power BI Desktop (@Eno1978) 5 MORE POWER BI TIPS (@sqldusty) Power BI Mobile Apps Update – June 2016 Whitepaper: Bidirectional Cross Filtering
