The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello!
I need to extract all the information from a workspace, including how much time a dataset takes to refresh in a day, the interval, the dataset's name and what time which one is going to refresh.
I've tried to extract in the Admin Portal, but it only brings me the last time refreshed.
Can anyone help me?
@GRMala - Are you using Premium Capacity? If yes, then please check the Power BI Premium Capacity Metrics App or you can go through the route of setting up Azure Log Analytics.
https://powerbi.microsoft.com/es-es/blog/introducing-power-bi-premium-capacity-metrics-app-as-a-temp...
Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.
Also, I would ❤ Kudos if my solution helped. It is a token of appreciation!
Thank you very much !
@gauthamboppana thanks for answering, I followed the steps, but it didn't work, because I need all the information (refresh) about all the datasets in the workspace, including each time executes each dataset, for example:
Dataset PowerBI Refreshes at: 7:00 AM; 9:00 AM; 11:00 AM with Interval = 2H or Average Refresh Time = 10
minutes...
I need to get this refresh information and put in the SQL Server.
User | Count |
---|---|
43 | |
15 | |
12 | |
11 | |
8 |
User | Count |
---|---|
51 | |
31 | |
20 | |
18 | |
15 |