If you want to use Python scripts with published reports, then you'd either need to... 1. Update data locally, and republish to update the report in Power BI service 2. Install a Data Gateway and configure the published report to update via the data gateway (which will connect to a machine with Python installed, and run the script). It seems you'd need to use a personal data gateway... powerbi.microsoft.com/en-us/gateway/ learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode
Hi there, I'm guessing you're talking about SpeakerID showing as [List] when importing. When you have these type of situations you have a few options. This hopefully gives some ideas (it's originally for Excel, but should be applicable to Power BI too)... support.microsoft.com/en-au/office/work-with-a-list-record-or-table-structured-column-power-query-d5e552be-c143-4f06-9a5e-0960bbaaf480
Really useful series TY. My only comment would be about audio quality! It's difficult, even as a native EN speaker, to hear/understand what is being said during the video. I have to turn the volume up to max. Rgds/pgr
Apologies - I realised the audio output was really low. Unfortunately I'd need to replace the video to fix it, but have definitely taken note, as I was using new software, and didn't spot the level issue before uploading.
Hi there, I'm guessing you're looking at importing the Speaker name (or other associated 'people' fields, like Created By, Modified By etc - to each row)? The ID field In this case, I think would be the unique ID of the Session. To get the speaker name you'd need to transform the data on import (using Power Query), and 'expand' the Table in the Speaker field, to get the 'value' of the person. SharePoint stores 'people' with their various fields like email, title etc. Hope I've understood correctly...