Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Getting data schema from pbix file

Hi all,   Is it possible to automatically (using bash or python for example) get schema of data that is used by PowerBI report? I know pbix files can be unpact and there is a lot of informations a...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous,

 

Sure, so I have a PowerBI report which is getting data from Azure Analysis Service. Both of these are pretty complicated (there is a lot of tables and views in AAS and couple of widgets in report). And because of it I'd like to create some tests for checking compability of report and model. To do that I'd want to somehow get schema of data used in report and just compare it with schema from Model.bim. By schema I mean names of tables and columns within them, maybe also relations but not necessarily.

 

Br,

Piotr.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI Anonymous,

 

AFAIK, current analysis service support import and live connection mode to get data.

 

For import mode, it require your to get data to power bi and will break existed your table relationships and data type.

For Live connection mode, it will disable most of edit features include the relationship panel and query editor.

So I think it is hard to achieve your requirement through power bi desktop.

 

 

Regards,

Xiaoxin Sheng