cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
palashaich
New Member

PowerBI Usages Data In Excel Not Loading Due To Many Records. How to remove report views with 0.

Hello there,

 

I need to bring PowerBI usages data in a SQL server table. I was not able to hit the XMLA endpoint due to authentication issue.

The alternate solution I am going with is to pull data in a excel using Analze In Excel Feature. Later, I am refreshing the excel and populating in DB.

 

The excel data not refreshing due to many records. I am getting for each users for all the reports and dates combination of records even though there are no views for few days and few reports. The data was coming in excel as 0 report views. If I can remove all the rows with 0 report views in excel, the number os records will be less. Please let me know how to remove records with 0 report views. If I filter only for one users and value filter in date with report views > 0, it works. While trying to get data for all the users, the report views > 0 doesn't work. Also, how can I get the data only for last 3 days.

 

palashaich_0-1632638985419.png

 

Thanks,

Palash

1 REPLY 1
GilbertQ
Super User
Super User

Hi @palashaich 

 

I would suggest rather use the Reporting metrics API to get the data from the Power BI Service. 

This will allow you to get all the data down and store it locally. You could then use the CSV extract to quickly and easily import this data into SQL Server.

 

Here is a blog post on how to achieve this: Usage Monitoring with the Power BI API – Activity Log (Audit Log) Activity Event Data – Jeff Pries (...





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!