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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
skumar0105
Helper II
Helper II

Can i Push Usage Metrics report data to SQL database

Hi

I have developed a customised report for tracking the usage of my original dashboard.

the tracking report includes few labels from report usage metrics and few from the other tables available in SQL database.

 

is there a way to to push Usage metrics report data to SQL database on a scheduled period of time.

so that i can merge both tables in my tracking report.

 

as of now i am doing this manually by exporting the underlying data of views in usage metrics report.

 

any suggestion or alternate is most welcome.

 

Regards
Satish

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

Hi @skumar0105 ,

Current power bi not contains any functionality to automatically export usage metrics. You can manually export these records by power bi export feature(refer the below) or submit an idea for this requirement.

Click "file" on the top left corner to see the option:save a copy then export to excel. Then import data to Sql.

vluwangmsft_0-1669688656195.png

 

 

 

 

 

Best Regards

Lucien

View solution in original post

1 REPLY 1
v-luwang-msft
Community Support
Community Support

Hi @skumar0105 ,

Current power bi not contains any functionality to automatically export usage metrics. You can manually export these records by power bi export feature(refer the below) or submit an idea for this requirement.

Click "file" on the top left corner to see the option:save a copy then export to excel. Then import data to Sql.

vluwangmsft_0-1669688656195.png

 

 

 

 

 

Best Regards

Lucien

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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