Power BI

If you need a custom queryable property on a user object - this is how we do it

Microsoft Graph toolkit is amazing, but unfortunately not available for Power Apps - Let's fix that!

In this blog I show one of the best ways to enforce the latest version of your Power App so that users aren't using an outdated version.

In this post I will show how to call Dataverse Custom APIs from a Canvas App with the use of a generic Power Automate Flow and the new ParseJSON functionality.

Improve performance and gain more control over your SharePoint data in Power BI by using the SharePoint API.

In dieser Folge vom BI Thinkers Talk haben wir über die neusten Entwicklungen in der Community gesprochen, wie zum Beispiel die Measure Totals Diskussion

This article explains how to create a Bravo for Power BI template to customize a Date table and the related Time Intelligence measures created by the tool.

Have you ever wished Power BI knew the optimal number of periods to show? It is possible with my Smart Axis Magic :) ! Here is how to improve UX by creating a smart date axis that automatically picks the optimal calendar period based on the timeframe. In this step-by-step explanation we dive deeper into field parameters, data modeling, and DAX. Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :) Download link: https://my.datatraining.io/course?courseid=howtopowerbifiles *See improved solution in the download files, where you don't need the bridge table and can use a between date slicer -------------------------------- 📊 TRAININGS 📊 --------------------------------- New! Power BI Design 4 Weeks Transformation Program https://my.datatraining.io/pages/powerbidesigntransformation Learning Path https://my.datatraining.io/subscriptions?id=power-bi-zero-to-hero For Custom Trainings and Consulting email directly support@datatraining.io --------------------------------- ⏱️ TIMESTAMPS ⏱️ --------------------------------- 00:00 Intro 01:43 Step 1 - Creating a field parameter with periods 03:23 Step 2 - Creating a helper table 07:17 Step 3 - Creating the relationships 09:14 Step 4 - Applying a TopN filter 10:14 Demo - smart date axis 10:55 Finishing touch - Dynamic title 13:40 End --------------------------------- 😍 JOIN 😍 ---------------------------------- Subscribe: https://bit.ly/31MnQGO​ Website: https://www.datatraining.io Facebook: https://www.facebook.com/groups/howtopowerbi LinkedIn: https://www.linkedin.com/company/datatraining-io Insta: https://www.instagram.com/howtopowerbi/ Twitter: https://twitter.com/HowToPowerBI --------------------------------- 👇 CHECK THIS OUT! 👇 --------------------------------- 💻 My gear https://a.co/69HEjRu 📚 Power BI books MUST READ! https://a.co/5q5k6Dv 💡 General books I recommend https://a.co/05I4W2L 🎶 Music for my videos https://www.epidemicsound.com/referral/8pjcbj 🚀 For growing on YouTube: https://www.tubebuddy.com/bas 🏄 Stuff I use daily https://a.co/4V5CUJN * Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos! Thanks for being a part of this channel and all your support! 💪 🙏 #HowToPowerBI​ #PowerBI​ #DataTraining​ #powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

Quick Tip:Are you OCD like me?Wish you could align your tables in the model view but there are no alignment tools?1. Select the tables you want to align.2. Click on the lowest aligned table and smash it into the ceiling.3. Click and drag another table back down.#PowerBI pic.twitter.com/pV3ooZSJG1— Kim Preece (@KNPBI) November 3, 2022

Probably one of the most annoying things about creating bookmarks is... updating them! However, there is a trick that will make your life so much easier and the process a lot faster. And the trick is... GROUP YOUR VISUALS and always select the option "SELECTED VISUALS" when creating your bookmark Let me get into the details now... The steps you need to do for this technique are: Group the visuals/shapes in your report (create kind of reporting areas) Using the Selection Pane, select the grou

This session will teach campers how to use the new SDK support to initiate an embedded Quick Create session which allows the user to dynamically build a new dataset and report on the fly.

In this post, we look at how to create our own SQL Database and fill it with data from the Contoso Data Generator, so we can get some hands-on Power BI experience.

Blogging about Power BI, Power Platform and other things I find interesting.

How does the Optimize ribbon, with Pause visuals, Refresh visuals, Optimization presets, and Performance analyzer, as well as Edit relationships in the properties pane work to streamline your authoring experience? Here are some scenarios they can help you with! 1. Make changes to an existing DirectQuery report without running queries until you are ready 2. Create new visuals without running a query until you are ready 3. Create measures in a DirectQuery model without the visuals refreshing until you are ready 4. Quickly edit relationships between DirectQuery tables 5. Quickly learn about and apply query reduction settings to your DirectQuery report 6. Adjust the query reduction settings to the level you need in your DirectQuery report 7. Quickly revert to the full interactivity after a data source change in your report

Roche’s Maxim of Community states: A community is defined by the behaviors it tolerates. I played the “maxim” card already a few months ago, I think it’s time to play it one…

A free test data generator and API mocking tool - Mockaroo lets you create custom CSV, JSON, SQL, and Excel datasets to test and demo your software.

Over the last half year, I have been involved in many large migration projects from another BI tool to Power BI. All with a different setup, from Tableau, Microstrategy and from Analysis Services t…

Microsoft Dataverse is a set of data services, tables/schemas and security features that support Dynamics 365 and PowerApps.

Get connection string for localhost pbi file · GitHub

It's nice to see that #ChatGPT has found that many #dax functions are just #excel ones. It explains why it is shameless to suggest them. But you can guide the AI to something that works.A 🧵1/13 pic.twitter.com/bZafvz0esr— Marco Russo (@marcorus) December 10, 2022

The December 2022 release of Power BI Desktop includes three new DAX functions: OFFSET, INDEX, and WINDOW. They are collectively called window functions because they are closely related to SQL wind…

Data artistry

A VSCode extension to manage your PowerBI tenant using the Power BI REST API - GitHub - gbrueckl/PowerBI-VSCode: A VSCode extension to manage your PowerBI tenant using the Power BI REST API

Contribute to PBI-David/Deneb-Showcase development by creating an account on GitHub.

Announcing new Power BI Metrics features hierarchies and linked metrics.

As I am a big fan of Azure services and in particular Azure Functions, I recently focused my attention on the possibility to create a custom connector from an Azure service. Indeed, the field of po…

CSV? Parquet? Delta? Which file format should you use to get the best out of Synapse Serverless SQL pool? Let's demistify pros and cons of each file type!

Deneb-Vega data visualization examples - Power of Business IntelligencePower of Business IntelligenceBlog by Andrzej Leszkiewicz. Excel VBA and Power BI developer and consultant.Andrzej …

Have you ever wanted to extract information from a web page to use in a calculation, or as a reference for something else you may be working on? I have used similar functions in the past (pre Power …