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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MissM
New Member

Usage Metrics Report - no "Data View" or "Transform Data" available in Power BI Desktop

Hi!

 

I am connecting to "Report Usage Metrics Model" from Power BI Desktop. It connects and opens, but there is neither "Data View" on left pannel nor Power Quiery Editor available there.

MissM_0-1652197532875.png

 

I can see the data only at "Report View" if I create visualizations. No data transformations are available.

Should it be like this? Or how to activate this things?

 

Thank you in advance!

1 ACCEPTED SOLUTION
v-yanjiang-msft
Community Support
Community Support

Hi @MissM ,

After you connect to the Power BI datasets in Desktop, you can see a line in the lower right corner  like this:

vkalyjmsft_0-1652695388474.png

Not only the usage metrics report, all the report you connected to the Power BI datasets will get the same result: Power Quiery Editor and "Data View" are not available. Because Power BI Desktop connect to datasets in live connection mode, and this is the feature of live connection mode.

 

You can refer to this document for details: DirectQuery, Live Connection or Import Data? Tough Decision! - RADACAD

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yanjiang-msft
Community Support
Community Support

Hi @MissM ,

After you connect to the Power BI datasets in Desktop, you can see a line in the lower right corner  like this:

vkalyjmsft_0-1652695388474.png

Not only the usage metrics report, all the report you connected to the Power BI datasets will get the same result: Power Quiery Editor and "Data View" are not available. Because Power BI Desktop connect to datasets in live connection mode, and this is the feature of live connection mode.

 

You can refer to this document for details: DirectQuery, Live Connection or Import Data? Tough Decision! - RADACAD

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Tutu_in_YYC
Resident Rockstar
Resident Rockstar

Hey MissM,

Yup, that is common as you are "querying" dataset in the Power BI Service. You will not be able to see the transformation nor data view.

You can see data view and get access to Power Query transformation if you import data in Power BI desktop (or download the pbix of an existing report in a workspace*). Now you are just connected to existing (transformed, modelled, and ready for consumption) dataset.

*not for reports that are generated by Power BI service i.e Usage report


Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors