Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ovonel
Post Prodigy
Post Prodigy

build usage statistics dashbaord?

I am trying to create a single dashboard, where I can show usage statistics for different reports in different workspaces.

 

So far I am combining my Power BI datasets:

ovonel_0-1646393457343.png

 

 

 

 

Of usage…

ovonel_1-1646393457348.png

 

 

 

 

So far its ok, but I need a new dimension (user dimension); this dimension resides only on a sql server and a SSAS on premise that I have.

 

Is it a way to change this model to bring data from ssas (I don’t think so!), is there a way to take the model I created to sql server? Anyone attempted this before?

 

 

 

2 REPLIES 2
edhans
Super User
Super User

Yes, but it is in preview. Go to Settings, Preview, and turn on Direct Query of Power BI Datasets and Analys Services and restart. 

 

Then, reopen your report. You may need to click a URL at the bottom right that will allow you to make changes to the model. Then you can bring in data from other places.

 

Be careful though. The feature is still in preview, and you can have performance issues vs a pure Import model. If it is just a list of users, probably not a big deal unless you work at a multi-national with 300K users. Take a look at this article for more info. Relationships in Power BI and Tabular models - SQLBI



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Birry
Frequent Visitor

We use the Power BI activity logs to extract audit data from our entire tenant which we can then transform, integrate and model to our needs.  If you have not seen the following already, I suggest you give it a read: Build Your Own Power BI Audit Log; Usage Metrics Across the Entire Tenant - RADACAD

 

There are also some new features due soon out-of-the-box so to speak, though this in itself does not solve the user data enrichment requirement you have:

Get admin insights with central metadata and reports - Power Platform Release Plan | Microsoft Docs

 

Maybe have a chat with your local friendly Power BI admin?

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.