Matt Masson

@SQLSocialite @_christianWade @cwebb_bi It was all @cwebb_bi's invention and creativity. I just sat there.

@_christianWade @cwebb_bi @mattmasson needs to sell these on eBay!

And you know what? We still haven't announced the new (and I'll admit relatively small, but very nice) #PowerBI feature that I was expecting us to announce at Build...

@GuyInACube @SharePointMadam @diverdown1964 @IrishSQL @SQLZelda @SQLGator Nope, doesn't look familiar

@SharePointMadam @diverdown1964 @IrishSQL @SQLZelda @SQLGator I have no idea 😕 // @mattmasson maybe you know?

A little help for my friend? @GuyInACube @diverdown1964 @IrishSQL @SQLZelda @SQLGator

@Will_MI77 @wilreynolds @GuyInACube @mllopis @cwebb_bi You should be able to configure cloud based refresh for Big Query.

@wilreynolds @GuyInACube You mean Big Query, right? It *should* work. According to docs.microsoft.com/en-us/power-bi… you can use the "cloud to cloud" connection to do it in the service? @mllopis, @mattmasson or @cwebb_bi might know more...

PowerBi Friends, if I have data updating daily in BQ & I am on PBI Pro, would I have to refresh on the desktop daily & upload the file daily to get my pro dashboards to update, or can I connect PBI's hosted dash to BQ directly, so anyone w/ the dash can refresh? cc @GuyInACube

@cwebb_bi @notaboutthecell I updated the #pqsdk with VS2019 support over the weekend. VS Code has an M language highlighter, but not a code formatter. That is coming.

@notaboutthecell @mattmasson You do realise that the M formatting extension for VS Code has been available for a long time now? It only formats code though, you can’t run M in VS Code.

Every day I wake up. Stare long into the mirror. And say. "Today is the day." #PowerQuery #M #SDK #PowerBI

@EscobarMiguel90 @boxofficemojo Haha actually I think the first to do the boxofficemojo demo was @FaisalMo or @mllopis. It's fun to see how the demo has evolved over the years - more UI, less typing.

We’re moving to a new demo using data from @boxofficemojo - fun fact! The first person to do a demo of this webpage with #PowerQuery was actually @mattmasson

New session coming up on #PowerBI dataflows or #PowerQuery online! Check out the lineup @mattmasson @mllopis

@EscobarMiguel90 @mllopis Better jokes???! Must have been the accoustics of the room 🤨

+10 points to @mllopis for making better jokes than the ones @mattmasson did in his session. More laughs this time

@MikeAinOz Thanks! I've been accused of making it look too easy. :) I'm currently preparing an updated version of the MBAS conference next week.

@notaboutthecell @andremckay @SchreiberLars Ha! I'm not at all social on steam.

@mattmasson @andremckay @SchreiberLars One day @mattmasson will accept my Steam request. One day. Thanks for all the hard work on M. If you see an uptick in downloads I’m spreading the gospel. I’ve got some Q’s around Int8, Int16, Int32 and Int64.Type that I may throw together a video on for you to look at. #M

@notaboutthecell @andremckay @SchreiberLars We actually have an M formatter for vs code going as a side project. It's not too far off (like, weeks).

@andremckay @SchreiberLars @mattmasson I’ve been thinking on a prettifier - May be worth looking into building it.

@SchreiberLars It's a lot faster now, too. :)

Whoop whoop, #M intellisense is now everywhere (advanced editor, formula bar and add custom column window) in #PowerQuery in #PowerBI Desktop and is now GA. Great job @mattmasson

@EscobarMiguel90 @Vicky85m @GuyInACube @Kjonge Seems like calculated tables are the right way to go, and I'm surprised they aren't working. Maybe your DAX calculation is doing something it shouldn't? (like including the tables multiple times)

@Vicky85m @GuyInACube @mattmasson 10M isn't that much for a Data Model. I've done this with over 60M rows, but it does rely on your available resources. What could be happening here @GuyInACube @Kjonge ?

Dear Power BI experts, any idea when this can be fixed or any alternatives? ideas.powerbi.com/forums/265200-… #powerbi #pbihelp @GuyInACube

@GuyInACube @Vicky85m I can't imagine this being technically possible without a complete revamp of how everything works. Once you Union in M, it's all just a "table". If you want incremental refresh and caching, that has to be done at the data model/DAX level.

@Vicky85m I'm not aware of anything in the roadmap for this. @mattmasson any thoughts?

@ranbeerm @EscobarMiguel90 When a refresh token expires, the user must log in again. That's the whole point of the refresh token.

@EscobarMiguel90 @mattmasson ok thanks opened a ticket github.com/Microsoft/Data… Isn't refreshing the refreshing token silently supported? What should I do? :-?

@EscobarMiguel90 @mattmasson QQ on OAuth 2.0 support in #PowerBI custom connector. "Refresh" is called when access_token expires, but what happens when refresh_token itself expires? Is this scenario supported, will StartLogin be called silently? Can this scenario be handled? TQ.

@EscobarMiguel90 @ranbeerm Credentials will be treated as invalid. In the service this results in an error. In desktop, user would be prompted to login via Oauth flow.

@ranbeerm @mattmasson Hey! Id recommend that you post this on github github.com/microsoft/data… from my experience, no. It won’t do it silently, but I’ve never tried to add a “try” to it so it does the start login

@NickChobotar @EscobarMiguel90 @DMaslyuk @mllopis I hit a bug in the underlying control that prevents the parameter hints widget from disappearing. I'll come back to it after Add Column is done.

*checks @DMaslyuk latest tweets and notices nothing about this* this is pretty big news for all the #PowerQuery #PowerBI folks. Intellisense in the formula bar! Did you guys sneaked this thing in? @mllopis @mattmasson

@CurbalEN @EscobarMiguel90 @DMaslyuk @mllopis done.

@EscobarMiguel90 @DaveBenaim @DMaslyuk @mllopis Intellisense for Insert Column dialog is coming soon (April update). Took a bit longer than the others. Sorry!

@DaveBenaim @DMaslyuk @mllopis @mattmasson not available yet :( - but I'm totally fine with just the formula bar at this time. That's where I spend most of time when using Power Query tbh

@EscobarMiguel90 @CurbalEN @DMaslyuk @mllopis I kept going back and forth on whether it should wrap. It will in the Add Column dialog, but I kept the scrollbars for the formula bar

@CurbalEN @DMaslyuk @mllopis @mattmasson Wrapping the text in the formula bar?

Cold Open: Business Intelligence Edition (#BIPowerHour 2018) #PowerBI #SQLFamily #PBIFamily guyinacu.be/coldopen

@cwebb_bi @tonmcg Well the gateway infrastructure doesn't support dynamic data sources, and I'm not sure if / when that will happen. I'm also not sure it is wise to ever pull dynamic code from web locations.

@tonmcg I still have a feeling that the dev team should comment on this in case there are any non-obvious problems. @mattmasson ?

Using GitHub for version control for your #powerquery M functions in #Excel, #PowerBI, or #dataflows. See tonymcgovern.com/blog/power-que…