Best solution to improve performance of enterprise scale data
Hi Team, Calling Microsoft Fabric Experts! Need Your Guidance! Before the introduction of Microsoft Fabric, we relied on Dataflows Gen2 to connect to SQL sources, pull data, and transform it. For context, Dataflows sit inside workspaces and not within any Lakehouse/Data Warehouse. We then used these Dataflows as the source for our Power BI reports. However, with enterprise-scale data, this approach sometimes slowed down report performance. Enter Fabric's OneLake With OneLake storing data in Parquet and Delta table formats, performance can be significantly improved. I’m exploring the best way to leverage this, and I’d love your insights! Here are my two thoughts: Option 1: Create a Lakehouse. Bring in the existing Dataflows to create Delta tables. Use these Delta tables as the source for Power BI reports. Will this improve Power BI report performance? Option 2: Create a Lakehouse. Build a Pipeline within the Lakehouse to pull data directly from SQL. Use this transformed data as the source for BI reports. What’s your take? Your suggestions aren’t just helpful for me but could benefit many in the community. I truly appreciate the time and effort from those who love sharing their knowledge. Looking forward to hearing from the amazing experts out there! Thank you! SergeiBaklan
Adding an 'Events List' as a List Webpart
Possible at all/is there a workaround? I am trying to put an Events List and a List on one page. The idea is to let users view/add to both on one page. The problem: when adding a list webpart, the events list I need doesn't appear as an option. I searched the forums and did not find a clear solution. Is this possible at all? If I run an automate flow to push entries and changes back and forth to a duplicate list and an events list that would be recursive. Currently have a 'Webpart Tabs' webpart with a placeholder standard list on the top: Titled 'Events List A'. I want to put the actual events list in its place. Happy holidays and thanks!Working with Arrays of Ranges
OK, so strictly speaking an array of ranges is an error in Excel right from the outset. However, I set up an array of tables contained within the named Range 'allocatedRange', here shown with a red outline. I then set up a function that would return the range corresponding to a country SelectDataλ = LAMBDA(country, LET( countries, FILTER(TAKE(allocatedRange, , 1), markers = "Country:"), recordNum, FILTER(SEQUENCE(ROWS(allocatedRange)), markers = "Country:"), recordEnd, VSTACK(DROP(recordNum - 1, 1), ROWS(allocatedRange)), rangeRows, recordEnd - recordNum, countryArrϑ, MAP( recordNum, rangeRows, LAMBDA(start, rows, LAMBDA(TRIMRANGE(TAKE(DROP(allocatedRange, start), rows)))) ), XLOOKUP(country, countries, countryArrϑ)() ) ) The start and row count of each table is determined by using the string "Country:" as a marker and differencing row numbers. A combination of TRIMRANGE/TAKE/DROP picks out each range in turn and assembles them into an array by turning the range references into thunks (TYPE=128). The function SelectDataλ is used to look up any specific country and return the corresponding range. To demonstrate that the function indeed returns ranges, the COUNTIFS function is used to count the number of cities within each country that have a population exceeding 100 000. = LET( countries, FILTER(TAKE(allocatedRange,,1), markers="Country:"), countLarge, MAP(countries, LAMBDA(country, COUNTIFS(TAKE(SelectDataλ(country),,-1), ">1000000") ) ), HSTACK(countries, countLarge) ) The point of this post is to introduce the idea of treating tables as elements of an array, so allowing further tables to be inserted or removed dynamically. TRIMRANGE ensures that each range is sized correctly and MAP is used to analyse each table in turn. Whilst Excel throws hissy fits at being asked to store arrays of arrays, arrays of ranges, or nested arrays, it is perfectly happy to store arrays of functions. When evaluated, each element of the function array is perfectly free to return an array or even a range. The effect is to permit Excel to process 'arrays of Tables' faultlessly.Get-PnPSiteTemplate: The remote server returned an error: (403) Forbidden
I want to copy one site collection from one tenant to another, so on the source tenant, I created this App Registering and I grant it full control on SharePoint:- And I define to use secret for the authentication:- Then I run this command:- Connect-PnPOnline -Url "https://****.sharepoint.com/sites/****Integration" -ClientId "***" -ClientSecret "ptv**" Connecting with Client Secret uses legacy authentication and provides limited functionality. We can for instance not execute requests towards the Microsoft Graph, which limits cmdlets related to Microsoft Teams, Microsoft Planner, Microsoft Flow and Microsoft 365 Groups. You can hide this warning by using Connect-PnPOnline [your parameters] -WarningAction Ignore then i got this error, when i tried to Get the site template:- Get-PnPSiteTemplate -Out "Integration.xml" Get-PnPSiteTemplate : The remote server returned an error: (403) Forbidden. Any advice? i remember i did this operation 1 year ago and it worked well. ThanksDax measure not considering the filter context and not aggregating
Hi, I have the below visual and highlighted Dax is having problem: Below is Dax: noofdays = COUNTROWS(Calendar_) For the below selected filters, noofdays dax should display 60 for month of September 2024 and 62 for month of October 2024. The total aggregate value should be 122 days. But this dax is giving wrong values now. FYI, when I bring in DBName-Points_Id into the visual,it is giving correct values row by row but when removed it doesn't: FYR, My expected output should be like below: PFA file here Portfolio Performance - v2.15 (1).pbix Please let me know if you need further info! Thanks in advance! SergeiBaklan
Enabling a custom teams app to work in only in private chat
Hi, I have a use case where I created a custom teams application to give some feedback to the employees based on their performance. The user types in a command using @ and it opens up the bot. I want to enable this application to run only in private one on one chat with the employees. I tried to change the scope in manifest file to "personal" for achieving this, but I believe it makes the application for the personal use only. How can I make it available in private chats only?Graph api :Fetching Call Records with Participant Join/Leave Times & Device Information
hello Microsoft Teams Developer Community, I’ve been working on a script to fetch detailed information about call records using the Microsoft Graph API. The script is designed to capture not just the basic call information but also the join and leave times of participants and the devices used during the call.call details with devce info and participant join,leave time
i am working on teams integration project when i run grap api it does not show data for device and participant timing details graph api for extacting data for call including { "call_id": "004998be-da70-40f6-999a-3c84484c98b1", "start_date_time": "2024-12-17T11:53:14.9897859Z", "end_date_time": "2024-12-17T12:16:55.6045446Z", "participants": [ { "participant_name": "Surbhi Yadav", "join_time": "Unknown", "leave_time": "Unknown" },
Extracting Device and Participation Details in Microsoft Teams
Hi everyone, I am working on a project for my organization to extract detailed information about Teams calls. Specifically, I need to gather data on the devices used by participants, as well as their join and leave times for each Teams meeting. This includes both participants and organizers. My current approach involves: 1. Using Microsoft Graph API to access call and participant data. 2. Fetching relevant details such as device type, join time, and leave time. - What are the best practices for extracting and managing this data? - Are there any specific API endpoints or techniques you recommend for efficiently retrieving this information? - How can I ensure the accuracy and completeness of the data collected? - Are there any tools or libraries that can simplify this process? Looking forward to your insights and experiences! Thanks in advance for your help!
