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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors