Matt Masson

Data Integration @ Microsoft

[Matt Masson @mattmasson]

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

[Matt Masson @mattmasson]

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

[Matt Masson @mattmasson]

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

[Matt Masson @mattmasson]

@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.

[Matt Masson @mattmasson]

@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.

[Matt Masson @mattmasson]

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

[Matt Masson @mattmasson]

@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.

[Matt Masson @mattmasson]

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

[Matt Masson @mattmasson]

@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).

[Matt Masson @mattmasson]

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

[Matt Masson @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)

[Matt Masson @mattmasson]

@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.

[Matt Masson @mattmasson]

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

[Matt Masson @mattmasson]

@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.

[Matt Masson @mattmasson]

@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.

[Matt Masson @mattmasson]

@CurbalEN @EscobarMiguel90 @DMaslyuk @mllopis done.

[Matt Masson @mattmasson]

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

[Matt Masson @mattmasson]

@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

[Guy In A Cube @GuyInACube]

Cold Open: Business Intelligence Edition (#BIPowerHour 2018) #PowerBI #SQLFamily #PBIFamily
https://t.co/LjMOphvoek

[Matt Masson @mattmasson]

@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.