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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.