Azure Infrastructure for the Power BI Data Consumer
Access denied, connection could not be established - this is exactly what you want to see when trying to connect to your data sources on Azure! With more and more data sources being hosted in the cloud and specifically on Azure, it has become more relevant to understand the different data services on Azure, as well as the options for connecting to these data sources. In this session we will walk through the different data sources in Azure, the different ways to connect to these data sources and what you need to consider when working in Power BI Desktop and Power BI Service. You will be smoothly connecting to all your Azure data sources in no time!Why Do My DAX Formulas Return Wrong Results?
Why Do My DAX Formulas Return Wrong Results? This session will focus on some of the common DAX formula mistakes beginners make when building measures and calculated columns. I will share examples and solutions that I have encountered in helping members of the Power BI community. Agenda: Introductions (5 mins) Presentation (55 mins) Q&A session (15 mins) About Fowmy Abdulmuttalib: Fowmy is the founder of ExcelFort Consulting and Training. He is a Microsoft Certified Data Analyst, Power BI SuperUser and an experienced Finance Professional with skills in Business Analytics and Financial Reporting. This event is online. You may need to install Zoom: https://zoom.us/download Space is limited so reserve your seat. Contact with Fowmy Abdulmuttalib: LinkedIn: https://www.linkedin.com/in/fowmy/ Members participating in Meetup Live events must be respectful in interactions with people and in content posted on the platform.Visual calculations: Making DAX easier | Jeroen ter Heerdt
This is the moment that changes everything. From today, writing DAX will never be the same. Discover how in this session! The Power BI team has been hard at work on groundbreaking advancements in DAX calculations, specifically designed to simplify adding common business metrics like running totals or comparisons to the first value. Imagine this: creating complex calculations without even typing DAX! In this session, we’ll unveil this revolutionary new feature that will transform how you approach DAX, making it faster and easier than ever. Don’t miss this chance to experience the future of DAX – prepare to be amazed!
PowerBi Pro Error
I have a user (assigned a pro license) getting this error whenever he tries to open a dataset that has been shared with him. I made sure he and the original creator of the data set both have pro version, the user has the most up to date version of ProBi, but we still get the error attached below. I have tried opening the data sets on the desk top app as well as web version. Any advice?
Need help with DAX formula
I am having difficulty in finding out correct way of displaying the below output. I have a table containing columns such as - Contract Name, Contract Start date, Contract end date, Total amount of contract, Status. The output i want to achieve is a bar chart of each month to see which contracts are Live or expired. But each month should carry a total value of contract NOT the allocated value of contract according to number of days in between the start & end date. Example data: Input Contracts Start End Amount Status Con-01 10/01/2020 26/10/2020 110,000.00 Expired Con-02 05/05/2020 09/05/2021 140,000.00 Expired in last 3 months Con-03 04/08/2021 26/08/2022 190,000.00 Not started Con-04 31/12/2020 13/10/2021 30,000.00 Live Con-05 29/02/2020 20/10/2020 80,000.00 Expired Con-06 01/05/2020 31/08/2021 150,000.00 Live Con-07 25/05/2020 24/05/2021 185,000.00 Expired in last 3 months DATA in model: Contracts Month Monthly Amount Con-01 Jan-20 110,000.00 Con-01 Feb-20 110,000.00 Con-01 Mar-20 110,000.00 Con-01 Apr-20 110,000.00 Con-01 May-20 110,000.00 Con-01 Jun-20 110,000.00 Con-01 Jul-20 110,000.00 Con-01 Aug-20 110,000.00 Con-01 Sep-20 110,000.00 Con-01 Oct-20 110,000.00 Con-02 May-20 140,000.00 Con-02 Jun-20 140,000.00 Con-02 Jul-20 140,000.00 Con-02 Aug-20 140,000.00 Con-02 Sep-20 140,000.00 Con-02 Oct-20 140,000.00 Con-02 Nov-20 140,000.00 Con-02 Dec-20 140,000.00 Con-02 Jan-21 140,000.00 Con-02 Feb-21 140,000.00 Con-02 Mar-21 140,000.00 Con-02 Apr-21 140,000.00 Con-02 May-21 140,000.00 So on…. Hence, the output: In July-21, the Con-04 & Con-06 is Live whereas Con-02 & Con-07 is Expired in last 3 months. I want to show Live & expired contracts on each month bar. How can i achieve this? Thank you.PowerBI Connection Issue
Hi there, since yesterday PowerBI App gives below error message in some reports After checking the gateway for this data source, I saw that the connection is successful. It is also working fine in SSRS, Excel and SSMS. Then I tried in PowerBI Desktop to start a new connection to that server and got below error The connection details are: Analysis Services, live connection. Any idea what could be the issue?line chart/KPI disappears while selecting filter
I have the below Visualization in Power BI Desktop. When I apply filter at page level then the line chart disappears except one. All the line charts have forecasting. Is there any way/setting to handle this blank line charts. NOTE: I have another page in this visualization in which KPI is going blank Before applying Filter After applying Filter
