Power BI Unchained

I recently ran into a snag when I wanted to use Power BI for some projects at home. Like any curious data enthusiast, I downloaded Power BI Desktop to my personal laptop, excited to dive in. Almost straight away, I was met with an all-too-familiar screen: Power BI kept asking me to enter my email address.

I am sure many of us are familiar with this screen

.

If you’ve ever tried this, you probably know the one I’m talking about—it only likes work or school emails, not our regular personal ones! I didn’t want to go through the hassle of setting up a special office account, especially if it meant worrying about trial periods or future costs.

So, I went digging online for a workaround. After trying a few things, I found a simple fix that worked perfectly: In Power BI, head to the Options menu, look under Preview Features, and disable something called “Translytical Task Flow.”

That’s it! Once I did that, the annoying email prompt was gone, and I could finally get back to building reports for personal use—without jumping through extra hoops or paying for things I didn’t need.

If you’ve been frustrated by this, hopefully this little tip saves you some time and headaches

Table Names in the database and the last time they were Updated

Ever wondered to see all the tables names and the last time they were updated?

This is a query which will give you all the desired result.

Select
Distinct Object_name(object_id) as DatabaseName,
Object_id,
Database_id,
Last_user_update
From
Sys.dm_db_index_usage_stats
Where
database_id = db_id() and last_user_update is not null