search

microsoft / powerbi-jupyter

A Custom Jupyter Widget Library for Power BI
MIT License
462 stars 149 forks source link

extract visual data from report in python script and not in jupyter notebook widget. #41

Open premanand09 opened 1 year ago

premanand09 commented 1 year ago

Hi, I have tried this library to embed report in jupyter notebooks. But I want to extract the data from report visuals in python script and run through commandline. Currently report is getting embedded after calling Report() on jupyter notebooks only. When i try to run the same thing in python script commandline it says report is not embedded. Could you please suggest me some resource which i can use for reference to extract data from power report visuals in python .py script.

moltra commented 1 year ago

I am getting ready to start using this package to try and pull data, if I can, I will let you know.

CrasCris commented 4 months ago

I am getting ready to start using this package to try and pull data, if I can, I will let you know.

Did you find the way to how to do it ?

Mike-Honey commented 1 month ago

I'm facing sort of similar challenges - I've stayed with the notebook but trying to use Run All to work through the rendering and then interacting with reports. But it seems quite flaky in that mode.

Visually I can see there's a lag between the "report" cell that renders the report and the actual report output becoming visible. So I tried adding a wait at the start of the next cell, but I still often stalls, errors or gives incomplete results. If anyone can figure this out, please let us know.

So for now I'm stuck with running the cells down to the "report" render, then waiting for "a while", then running the rest of my cells.

Here's my project fwiw - I wrote it to be generic for any report. https://github.com/Mike-Honey/powerbi-export-all-visuals