Template for Extracting Report Level Measures from Live Connection PBIX Files

Подписаться 30 тыс.

Просмотров 3 тыс.

50% 1

Learn about a report I built that will connect to any local (PBIX) file that is using a live connection, and extract any report-level measures from that file. Live connections include (PBIX) files connected to: SQL Server Analysis Services (SSAS) models, Azure Analysis Services (AAS) models, and Power BI Shared Datasets.
Stephanie Bruno - Power BI Field Finder
github.com/stephbruno/Power-B...
Tweet from Marco Russo about unzipping PBIX files
marcorus/status/1...
LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
HAVENS CONSULTING PAGES 📄
Home Page - www.havensconsulting.net
Blog - www.havensconsulting.net/blog-...
Blog Files - www.havensconsulting.net/blog-...
Files & Templates - www.havensconsulting.net/files...
Consulting Services - www.havensconsulting.net/consu...
Contact & Support - www.havensconsulting.net/conta...
EMAIL US AT 📧
info@havensconsulting.net
#PowerBI #PBI #microsoftpowerbi #HavensConsulting #powerplatform #microsoft #businessintelligence #datascience #office #data #digitaltransformation #dataanalytics #tableau #excel #powerapps #datavisualization #dashboard #sharepoint #python #bi #analytics #cloud #azure #bigdata #sqlserver #software #sql #dynamics #dataanalysis #yammer #microsoftpowerbi #onedrive #machinelearning #bhfyp #powerbidesktop

Наука

Опубликовано:

21 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 14

@heatherr5191 4 года назад

Reid, this is awesome! Thank you for making such a valuable resource available to the community! Love what I'm learning from your channel.

@HavensConsulting 4 года назад

Thanks Heather!

@jeromelouvel732 4 года назад

Nice stuff! Thanks a ton :)

@myrandomandboringvideos 2 года назад

Ohh, this is a saviour!

@Nazeerul_Hazard 4 года назад

Hi While trying to run this I get following error (The field 'modelExtensions' of the record wasn't found.) Note this error pops up after I select a powerbi file into the parameter) Please help

@HavensConsulting 4 года назад

Hi there, is your model specifically a live connected model? Import models do not work with this.

@abhayverma2585 3 года назад

can this extract measures of Built-in power BI 'Usage Metrics Report' which gets produced from power bi service?

@HavensConsulting 3 года назад

It cannot as you can’t download that file, and those measures aren’t report level measures.

@abhayverma2585 3 года назад

@@HavensConsulting Thank you for your prompt reply. Is there any way to read the measure function they are using in those auto-generated reports?

@HavensConsulting 3 года назад

Not that I’m aware of, sorry. Those reports are under lock and key for now

@ARCHIEMAX 2 года назад

Can you make the report you showed that actually draws out the dax formula ?

@HavensConsulting 2 года назад

This should help solve that for you :) databear.com/how-to-view-and-retrieve-all-measures-power-bi/

@notoriousft 2 года назад

Not free anymore..

@HavensConsulting 2 года назад

You're right! It was free for two months as a promotion for when I recorded this video back in 2020. It's now part of the File collection I sell in my store. This one has a promotion for half-off (25 dollars) right now. :)