Mark Beedle

@netestapper I could be wrong, but I think it’s a Power BI feature, so I don’t think it’s even available in AAS.

@markbdi tx, and AzureAS only via XMLA right?

Has anyone had any luck creating a new Field Parameter table outside of #PowerBI Desktop? I tried to create one using the same #DAX that Desktop generates in #TabularEditor3 but with no luck.

@netestapper I don’t know for sure, but I highly doubt it.

@markbdi Do any of you know if field params will ever make it to on prem ssas tabular models?

@TheScree That is exactly how I originally interpreted it. That if my max is 8, up to 8 v-cores could be added in a single 24 hour period, but my interpretation is being challenged. This makes me think my original interpretation was wrong.

@markbdi You have to pick what the "max" v-core's you want to support with Autoscaling. You get charged the scaling cost, PER v-core you want to add in. So 8 x $85 in the example below. Link to configuration guide included: learn.microsoft.com/en-us/power-bi…

Need some #PowerBI help! The wording of the docs makes it sound like only a single v-core is added per 24 hour period. Can anyone confirm that? If I have a P1 and its peaked out, auto-scale will add 1 v-core? What if I'm still peaked out? No more v-cores until tomorrow?

@notaboutthecell @ehansalytics @YukitheJapanese I feel this in my bones.

I'm interested in engaging in a local #PowerBI User Group, but the group doesn't seem to have been active recently. I even sent a private message to the leader a while back, but haven't received a response yet. Am I better off participating in other user groups? 😂

Want to level up your #MarchMadness #Bracketology? Our Tournament model & bracket tool has everything you need to make #WinningPicks. From expert analysis to key metrics & insights, we help you uncover the hidden gems & avoid the upsets. Find out more at p3ada.pt/March-Madness

I think I’m the only one at my company that only uses my laptop monitor for most work. My main client laptop doesn’t even have a second monitor attached. This make me feel better.

Just noticed this in the #PowerBI service! Maybe it's been there a while and I'm late to the game, but holy smokes, batman, this is helpful!

It’s been a great day at #SQLSatATLBI! If you’re around and haven’t stopped by yet, please do…I love meeting people in the #PowerBI community!

@AgulloBernat You probably already know this, but if you turn scheduled refresh off before publishing, the publish of the pbix doesn't trigger an automatic refresh.

I would really like to publish a pbix file without triggering a refresh. Let me change the parameter value, then I'll take care of the refresh. And no, you cannot cancel an on-demand request

If you're coming to #SQLSatATLBI, stop by the @P3Adaptive booth and get some sweet swag! Really looking forward to meeting folks in person!

Want to become a part of the P3 Adaptive family? We are a tight-knit, fully remote community that supports each other every step of the way while prioritizing work-life balance and individual growth. Apply now! We can't wait to welcome you home. p3adaptive.com/careers/

Really enjoyed working through the examples of this video. Fun Saturday morning exercise! youtube.com/watch?v=bxSWQN…

@ecpdata By hidden table, do you mean a query that has "Enable Load" unchecked back in Power Query? These queries show up under Shared Expressions in TE. Tables that actually load into model but are hidden/invisible are shown under tables but slightly grayed out.

Hey #PowerBI experts, how do I edit a hidden table in Tabular Editor that is being used to build a merge query that isn't hidden? Is unhiding in desktop only option?

This sounds like a super fun and super nerdy episode! Can’t wait to listen!

@PawarBI @alexdupler @TheScree I thought v2 did take into account the filter pane. thebiccountant.com/2021/08/23/pow…

@alexdupler @TheScree Btw, I am doing this to identify columns that can be deleted from an existing report. Power BI Cleaner etc don't factor in columns used in filter pane. If there is another way to find columns that can be deleted safely, please lmk.

It sure would be nice if you could easily find out which visuals have visual level filters applied in #PowerBI desktop. May be an icon or a table. Is there anything I am missing?

@Haquafresh Do you have a Calculation Group in the model? Those hidden measures/folder typically show up when Calc Groups are present. If you view hidden in the fields pane, you should be able to see them.

More #PowerBI weirdness today... a sneeky bug? Adding a field measure to conditional formatting, it shows a display folder called "Format String Measures". The weirdness is that, that subfolder doesn't exist in my model, some back end metadata sneaking through perhaps?

Coolest place to work on the planet!

P3 Adaptive is hiring a Data Engineer! Do you know #SQL, #DataWarehousing, & ETL? Are you excited to use #Azure Data Factory & Azure #Synapse? Have you built Data Storage Solutions w/ SQL Server & #DataLakes? Dabbled in #PowerShell or Python? Apply at p3ada.pt/3uk89EC_Data_E…

@CJMajka I think 1:1 relationships always default to bidirectional.

Any reason #PowerBI would default to cross filter both directions on 2 of the relationships? It should be single like the others...