Louis Pitchforth

👩‍💻 Data Analyst ➡ Salary: up to £49,575 🏢 Location: Leeds, Manchester or Newcastle Apply now on our website: civilservicejobs.service.gov.uk/csr/jobs.cgi?j… #PlanForJobs #DigitalJobs

@drryandunn Shouldn’t that be: “…man-woman-man” . Sorry. Still beautiful either way.

what a place man 💙

We have another accessibility specialist role, with a focus more on Microsoft 365 products, if you want to work with the awesome @Drewst1505 - civilservicejobs.service.gov.uk/csr/index.cgi?…

@MMarie graph.microsoft.com - so much data across a variety of resources. Always some new data to mix.

Hey, #PowerQuery friends, what APIs do you like to connect to with Power Query to get data into Power BI? I'm making a presentation and need some more examples.

👩‍💻 #Microsoft O365 Infrastructure Engineer ➡ Salary: up to £41,480 🏢 Location: #Leeds or #Manchester Apply now on our website: civilservicejobs.service.gov.uk/csr/jobs.cgi?j… #PlanForJobs #DigitalJobs

@triweasel @drryandunn You’re right, integrations across other Microsoft tools would be nice. I think Microsoft want people to move to Premium and consider Deployment Pipelines.

@triweasel @drryandunn Would enjoy a coffee N chat to share ideas further - you buy 😉

@triweasel @drryandunn Version control of the pbix (package sync from / to the Power BI portal) Vs Version control of the M code in Power Query will have different challenges and solutions. Dataflows will help you create M code and share the output dataset, due to lack of Power Pivot/BI Desktop on Mac.

@PowerBIguy linkedin.com/posts/murilo-g… - perhaps?

Shout out to all the people who love a puzzle, are analytical thinkers and enjoy working with latest cloud technologies…this may be the role for you. Apply before Sunday 21/11, GO!

@CatherineCe @DWPDigital I do, I’ll drop you a message.

Massive congratulations to the team who created our Room Booking Tool in Teams. It's really easy to use. Do you know who I can contact about how good it is @DWPDigital?

@triweasel @drryandunn This sounds like “something” that might be repeatable elsewhere with positive outcomes. If so, would love to see how we can adopt too.

Looking for a new opportunity in a digital role? Comfortable asking questions? Like to analyse information? Want to help make things better? Enjoy working as part of a team? This maybe the new #opportunity for you, why not take a look… civilservicejobs.service.gov.uk/csr/jobs.cgi?j…

@BrianTJackett @ChristosMatskas @Path2SharePoint @YannickReekmans @LuiseFreese @waldekm @AzureAndChill @MSFTReactor @AzureFunctions @microsoftgraph @jthake @sebastienlevert Thanks for your help: I have posted the question Microsoft Q&A as advised and also created a supporting repo in git. github.com/pitchfol/graph docs.microsoft.com/en-us/answers/…

@ChristosMatskas @LouisPitchforth @Path2SharePoint @YannickReekmans @LuiseFreese @waldekm @AzureAndChill @MSFTReactor @AzureFunctions @microsoftgraph @jthake @sebastienlevert Which question / scenario in thread looking for input on? Long thread so far. If feature request recommend share on aka.ms/m365dev-sugges….

Hey @ChristosMatskas @AzureAndChill, @YannickReekmans is looking for a PowerPoint deck explaining our identity story: scopes, flows, etc. Do you have something that you could share with him?

@Path2SharePoint @YannickReekmans @ChristosMatskas @LuiseFreese @waldekm @AzureAndChill @MSFTReactor @AzureFunctions @microsoftgraph @jthake Haven’t raised a case, as the endpoint is beta - good shout tho. I have tried with just ten records and the same inconsistencies occur. May just be my code isn’t as robust as need to be. Will keep working at it - thanks :)

@LouisPitchforth @YannickReekmans @ChristosMatskas @LuiseFreese @waldekm @AzureAndChill @MSFTReactor @AzureFunctions Did you report it to Microsoft? They might be interested to look into your scenario. Also, sometimes throttling gets in the mix, I have addressed it in #SPFx but I wouldn't know how to deal with it in #PowerBI. @microsoftgraph @jthake

@Path2SharePoint @YannickReekmans @ChristosMatskas @LuiseFreese @waldekm @AzureAndChill @MSFTReactor @AzureFunctions Oddly some days the query works and returns what is expected, some days the query returns an error. Very frustrating, maybe when/if the version moves from beta to 2.0 the ODATA query options will be respected and stable. Thanks and have a great day 👍🏻

@LouisPitchforth @YannickReekmans @ChristosMatskas @LuiseFreese @waldekm @AzureAndChill @MSFTReactor @AzureFunctions Right. That's where my client decided Planner export to Excel was a better data source than Planner Graph 😉 I sure wish the #MicrosoftGraph did a better job at leveraging $expand.

@Path2SharePoint @YannickReekmans @ChristosMatskas @LuiseFreese @waldekm @AzureAndChill @MSFTReactor @AzureFunctions Thanks for the reply :) Some data is a parent and has child items that can be expanded. For example groups can have members. You can expand members to see who is a member of a particular group.

@LouisPitchforth @YannickReekmans @ChristosMatskas @LuiseFreese @waldekm @AzureAndChill @MSFTReactor @AzureFunctions I haven't. Not sure what you do when "navigating a record", I just retrieve rows in bulk with odata.

@Path2SharePoint @YannickReekmans @ChristosMatskas @LuiseFreese @waldekm @AzureAndChill @MSFTReactor @AzureFunctions Hi @Path2SharePoint. I also have a PBI graph query working, one single query to get the token and pass into the graph get request (as the bearer in the header). Getting data as an odata feed works, however often throws an error on navigating a record. Have you experienced this?

@YannickReekmans @ChristosMatskas @LuiseFreese @waldekm @AzureAndChill @MSFTReactor @AzureFunctions oh ok, I believe I hit a wall there too. What I did was write the Power Query directly in the editor. Two queries actually, one to retrieve the token and the other - OData.Feed - to call the Graph.

@StevieSUV Got some licenses, feel a pilot coming on…Get your Battle Cat ready 🤟🏻

#MastersOfTheDataverse youtu.be/VR3tYrnLdls

@StevieSUV - could come in handy: powerbi.microsoft.com/en-us/blog/ann…