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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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:






Of usage…






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?




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

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors