fbpx

How to get a CLOCK in your Power BI Report

We had a question about how to get a clock in Power BI? Is that even possible? Patrick takes advantage of the Deneb visual to make it happen! Vega Clock Sample https://vega.github.io/vega/examples/clock/ HTML Content Custom Visual Limitations https://www.html-content.com/reference/limitations Kerry Kolosko https://kerrykolosko.com/exploring-deneb-for-power-bi/

How to get a CLOCK in your Power BI Report2023-02-22T09:22:25-05:00

Checking out the Window Clause in Azure SQL and SQL Server 2022

Partitioning is nice in SQL, but how about using the WINDOW clause to make it more efficient? Patrick looks at how to use this function with Azure SQL and SQL Server 2022! SELECT - WINDOW - (Transact-SQL) https://learn.microsoft.com/sql/t-sql/queries/select-window-transact-sql?view=sql-server-ver16

Checking out the Window Clause in Azure SQL and SQL Server 20222023-02-21T08:52:21-05:00

๐Ÿ”ด Power BI tips from the Pros – LIVE (Feb 18, 2023) (Member Chat 2nd Half)

Join us live as we answer your questions about Power BI! ๐Ÿ’ฅ 30 minutes: Open Q&A (Public) ๐Ÿ’ฅ Then... Members Only Chat (Public can watch & Super Chat for Questions) ๐Ÿ“ข RULES FOR Q&A: ๐Ÿ“ข ๐Ÿ‘‰ Put a "Q:" in front of your comment to help us identify questions! ๐Ÿ‘‰ Super chats take priority ๐Ÿ‘‰ [...]

๐Ÿ”ด Power BI tips from the Pros – LIVE (Feb 18, 2023) (Member Chat 2nd Half)2023-02-17T06:51:30-05:00

Publish/Migrate your RDL files from Power BI Report Server to the service

Using on-premises Power BI Report Server? You can now migrate your paginated RDL reports to the Power BI service from within the portal. Patrick shows you how! Plan to migrate .rdl reports to Power BI https://learn.microsoft.com/power-bi/guidance/migrate-ssrs-reports-to-power-bi Blog Announcement: https://powerbi.microsoft.com/blog/power-bi-report-server-january-2023-feature-summary/#post-21998-_Toc121395751 Public RDL files to Power BI https://learn.microsoft.com/power-bi/guidance/publish-reporting-services-power-bi-service?tabs=powerbi-report-server

Publish/Migrate your RDL files from Power BI Report Server to the service2023-02-15T07:20:36-05:00

Provide data lake access with Azure Synapse Analytics

Using a lake database with Azure Synapse Analytics and struggling to figure out permissions needed for your data readers? Patrick and Adam show you what's missing! Azure Synapse Access Control https://learn.microsoft.com/azure/synapse-analytics/security/synapse-workspace-access-control-overview How to set up access control for your Azure Synapse workspace https://learn.microsoft.com/azure/synapse-analytics/security/how-to-set-up-access-control Control storage account access for serverless SQL pool in Azure Synapse Analytics [...]

Provide data lake access with Azure Synapse Analytics2023-02-14T08:02:43-05:00

๐Ÿ”ด Power BI tips from the Pros – LIVE (Feb 11, 2023) (Member Chat 2nd Half)

Join us live as we answer your questions about Power BI! ๐Ÿ’ฅ 30 minutes: Open Q&A (Public) ๐Ÿ’ฅ Then... Members Only Chat (Public can watch & Super Chat for Questions) ๐Ÿ“ข RULES FOR Q&A: ๐Ÿ“ข ๐Ÿ‘‰ Put a "Q:" in front of your comment to help us identify questions! ๐Ÿ‘‰ Super chats take priority ๐Ÿ‘‰ [...]

๐Ÿ”ด Power BI tips from the Pros – LIVE (Feb 11, 2023) (Member Chat 2nd Half)2023-02-10T07:13:55-05:00

Guy in a Cube answers the web’s most searched questions on Power BI

Let's see what the most asked questions are on the web about Power BI! Adam looks at google for the questions and then responds. You heard that right! He went to Google. Power BI forecasting https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane#apply-forecasting Describing the forecasting models in Power View https://powerbi.microsoft.com/en-us/blog/describing-the-forecasting-models-in-power-view/ Power BI on a Mac? https://www.youtube.com/watch?v=qUpqtWEOG40 Understand star schema and the [...]

Guy in a Cube answers the web’s most searched questions on Power BI2023-02-09T09:19:04-05:00

Time to look at the new INDEX function in DAX and Power BI

The latest DAX functions in Power BI can be very "power"ful! Patrick starts by looking at the INDEX function to solve a customer problem! Blog announcement: https://powerbi.microsoft.com/blog/power-bi-december-2022-feature-summary/#post-21693-_Toc121395731 INDEX function (DAX) https://learn.microsoft.com/dax/index-function-dax WINDOW function (DAX) https://learn.microsoft.com/dax/window-function-dax Chris Webb's Blog https://blog.crossjoin.co.uk/2023/01/02/why-dax-window-functions-are-important-for-performance-in-power-bi-directquery-mode/ Jeffrey Wang's Blogs on Window Function https://pbidax.wordpress.com/2022/12/15/introducing-dax-window-functions-part-1/ https://pbidax.wordpress.com/2022/12/23/introducing-dax-window-functions-part-2/

Time to look at the new INDEX function in DAX and Power BI2023-02-08T09:15:44-05:00

Continuing the T-SQL journey with OVER and RANK

Continuing our T-SQL journey, Patrick explores the use of the OVER and RANK functions in combination with common table expressions (CTE) in Azure SQL Database and Azure Synapse Analytics. RANK (Transact-SQL) https://learn.microsoft.com/sql/t-sql/functions/rank-transact-sql?view=sql-server-ver16 SELECT - OVER Clause (Transact-SQL) https://learn.microsoft.com/sql/t-sql/queries/select-over-clause-transact-sql?view=sql-server-ver16 WITH common_table_expression (Transact-SQL) https://learn.microsoft.com/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-ver16

Continuing the T-SQL journey with OVER and RANK2023-02-07T09:18:34-05:00
Go to Top