fbpx

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

Bringing Paginated into Power BI reports – INSANE AMAZING!

It's here! Have a look at the Power BI Paginated visual for your Power BI Reports! It adds additional flexibility for displaying data as well as providing easy export options if that's your jam. Blog Announcement: https://powerbi.microsoft.com/en-us/blog/paginated-report-visual-for-power-bi-reports-is-now-available-in-public-preview/ Documentation: https://docs.microsoft.com/power-bi/visuals/paginated-report-visual BIFOCAL Show Podcast: https://bifocal.show/ Jason Himmelstein's white paper: https://sharepointlonghorn.com/the-new-paginated-report-visual-is-here/

Bringing Paginated into Power BI reports – INSANE AMAZING!2021-08-04T07:11:08-05:00

Tracing with Log Analytics and Power BI

With Log Analytics integration in Power BI, you can now capture Analysis Services trace events easily and over a longer period of time. Combined with the Power BI template report, you can gain a lot of insights into usage of your datasets. With more to come down the road! Announcing long-term usage and performance insights [...]

Tracing with Log Analytics and Power BI2021-07-01T07:41:17-05:00

Tracing your DAX queries in Power BI

Learn how you can trace your DAX queries when trying to troubleshoot or optimize Power BI reports and datasets. There are a few options and Adam walks you through them. DAX Studio: https://daxstudio.org/ SQL Server Management Studio: https://docs.microsoft.com/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 Visualize Your Refresh: https://dax.tips/2021/02/15/visualise-your-power-bi-refresh/

Tracing your DAX queries in Power BI2021-06-10T06:01:59-05:00

🔴 Power BI tips from the Pros – LIVE /w Chris Finlan (Mar 6, 2021) (Member Chat 2nd Half)

Join us live as we answer your questions about Power BI! With special guest, Chris Finlan! Get your Power BI Premium Per User questions answered and of course anything else Power BI related. Connect with Chris: Twitter: https://twitter.com/cmfinlan YouTube: https://www.youtube.com/user/cfinlan Blog: https://christopherfinlan.com/ 💥 30 minutes: Open Q&A (Public) 💥 Then... Members Only Chat (Public [...]

🔴 Power BI tips from the Pros – LIVE /w Chris Finlan (Mar 6, 2021) (Member Chat 2nd Half)2021-03-02T07:47:02-05:00

🔴 Ignite March 2021 Social Hour with BIFocal

Join us live as we recap Power BI and Power Platform announcements made at Microsoft Ignite March 2021. With special guest, Jason Himmelstein and John White from The BIFocal Show podcast! Microsoft Ignite: https://myignite.microsoft.com/home Connect with Jason and John: Twitter: https://twitter.com/jasehimm Twitter: https://twitter.com/diverdown1964 Twitter: https://twitter.com/BIFocalShow Website: https://bifocal.show/

🔴 Ignite March 2021 Social Hour with BIFocal2021-02-24T09:28:30-05:00

Avoid the full refresh with Incremental Refresh in Power BI (Premium)

Is the full refresh of Incremental Refresh taking a long time? Or, even timing out? Patrick shows you how you can avoid the full refresh and refresh each partition individually when using Power BI Premium! Handling deletes within Incremental Refresh in Power BI: https://www.youtube.com/watch?v=nKVrl0ec6uE SQL Server Management Studio: https://docs.microsoft.com/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 ALM Toolkit: http://alm-toolkit.com/ XMLA Endpoint: https://docs.microsoft.com/power-bi/admin/service-premium-connect-tools

Avoid the full refresh with Incremental Refresh in Power BI (Premium)2021-01-27T07:34:27-05:00

🔴 Power BI Deployment, Governance and Q&A with Melissa Coates – LIVE (Jan 23, 2021)

Join us live with Melissa Coates as she shares some knowledge about Power BI deployment and governance followed by Q&A. 📢 RULES FOR Q&A: 📢 👉 Put a "Q:" in front of your comment to help us identify questions! 👉 Super chats take priority 👉 Do NOT re-post your questions! We'll get to as [...]

🔴 Power BI Deployment, Governance and Q&A with Melissa Coates – LIVE (Jan 23, 2021)2021-01-19T06:39:27-05:00

Getting started with Power BI Paginated Reports (2021)

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 [...]

Getting started with Power BI Paginated Reports (2021)2021-01-13T08:02:05-05:00
Go to Top