DAX Pro Services

Power BI / Business Intelligence Freelance Agency under construction. Stay tuned with our Power BI Tips! #PowerBI #PowerPlatform #Azure #AzureSynapse

[DAX Pro Services @dax_services]

Ever wanted to have a Query catalog of your entire #PowerBI workspace? Let's do it using #Azure Functions:

https://t.co/6moCHCPEXW

[DAX Pro Services @dax_services]

Friendly reminder: Power BI won't be able to do much if the underlying business data processed are not solid :(

[DAX Pro Services @dax_services]

By the way, there's lots to share after #mppc23 about #Fabric and #PowerPlatform 😀 #LasVegas

[DAX Pro Services @dax_services]

Been away for a while. We'll be back online again soon 😁

[DAX Pro Services @dax_services]

Ever wanted to have a Query catalog of your entire #PowerBI workspace? Let's do it using #Azure Functions:

https://t.co/6moCHCPEXW

[DAX Pro Services @dax_services]

What is the best way to start with #Azure #Databricks with hands on work right away in a project?

[DAX Pro Services @dax_services]

Calculator 🥲

[memes.xlsx @ExcelHumor]

favorite excel shortcut?

[DAX Pro Services @dax_services]

@ehansalytics *not about the memory* 🥶🥶🥶🥶🥶🥶

[DAX Pro Services @dax_services]

This is our religion too

[Ed Hansberry @ehansalytics]

Trial Balance.xlsx
Trial Balance v2.xlsx
Trial Balance v2 Revised.xlsx
Trial Balance v3.xlsx
Trial Balance Final.xlsx
Trial Balance Final Updated.xlsx
Trial Balance FINAL FINAL.xlsx
Trial Balance Totally Revised and Reviewed - FINAL.xlsx
Trial Balance v4.xlsx

[Ed Hansberry @ehansalytics]

@dax_services Then you do that by making people Viewers, but if the admins are the devs, then not much you can do. Just implement best practices and stick to the policies.

[DAX Pro Services @dax_services]

@AgulloBernat @SQLChick Endorsement here 🙌

[DAX Pro Services @dax_services]

We are starting to do our first steps using #PowerBI Deployment Pipelines. Amazing!!

However, question: how do you prevent datasets to be published to the Production stage directly? can you enforce publishing to previous stages first?

[Ed Hansberry @ehansalytics]

@dax_services No developers should have access to the Prod workspace, or if they do, VIEW only. But really no. Truly they should publish to DEV only, be Viewer in TEST, and no access to PROD - just the App if they need to see reports.

[DAX Pro Services @dax_services]

@ehansalytics Much like Git environments where the Master branch mergers are only allowed via Pull Request :) food for thought

[DAX Pro Services @dax_services]

@ehansalytics Thanks for participating esteemed gentlemen 🙂 and yes, I see the point, however, we work in a small environment where the handful of us are Admins. But it would be good to have that one Production workspace with deployment prohibited and only allowed via Deployment Pipeline

[DAX Pro Services @dax_services]

Hearing a happy client say how awesome the work you did is, is absolutely rewarding.

#DataAnalytics
#PowerBI

Let's keep making wonderful,actionable reports!

[DAX Pro Services @dax_services]

Things I know:
⭐DAX #PowerBI
⭐#PowerQuery/M
⭐Excel Guru
⭐SQL
⭐C# in Azure
⭐Python/Pandas

Things I don't know:
⭐PHP.
⭐Web programming.
⭐A myriad amazing other things.

Alone, we are strong, together as a community, we are invincible :)

[Ed Hansberry @ehansalytics]

Things I know:
⭐DAX
⭐#PowerQuery/M
⭐Excel Array formulas

Things I don't know
⭐SQL (beyond SELECT/WHERE clause)
⭐C#
⭐Python
⭐100 other things.

It is ok to know what you know & study those, or branch out into other things. Don't get caught up in FOMO though. #PowerBI

[DAX Pro Services @dax_services]

Today is the day to secure every single login by changing passwords and setting up MFA / auth codes :)

[DAX Pro Services @dax_services]

Just scored 955/1000 on DA-100 Analyzing Data with #PowerBI. Nice!

[DAX Pro Services @dax_services]

We have seen many times that customers want to move the Totals section of the #PowerBI matrix to the very first position on the left, instead of having to scroll all the way to the right to see their totals.

Vote and share if you agree! .@PowerBI
https://t.co/zqiZ6nI5pm

[DAX Pro Services @dax_services]

Is it only us? Or don't you think that the dataset view in #PowerBI is missing a SETTINGS button right after "Show Tables"??

We know it's possible to go to the dataset settings by clicking Refresh > Schedule Refresh. But that is not intuitive enough.

.@MSPowerBI