Forum Discussion

HennSarv's avatar
HennSarv
Helper I
6 years ago

PDF Connector for Excel

Is there ANY way to include PDF Connector into Excel PowerQuery?   on PowerBI it works fine but sometime need additional preparation or analyzis to do not awailable in just reporting PowerBI   He...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I have not found one but have the same need.

 

To get around the issue, I develop my transform in BI. Next, I copy and paste the data from the BI table grid into a text file. I then continue my transform in Excel off of this file. 

 

The process is kludgy, inefficient and probably limited by the amount of memory, but at least I am able to get my pdf data into excel.

 

  • HennSarv's avatar
    HennSarv
    Helper I
    6 years ago

    I'm using same workaround - but this isn't good enough and need manual intercelt

     

    Let have same need (feature request)

     

    On (bad) side on PowerBI is that all development worce is concentrated to PowerBi and left from Excel (original home for PowerQuery, PowerPivot and PowerView) - so Excel is more or less as Cinderella now in analytics. Same things goes to Excel now with big delay, lessfunctional or never