Power Pivot - Import data straight into power pivot instead of creating excel tables in order to reduce size of excel spreadsheet

:space_invader: What is the problem you need to solve? Importing details into Power Pivot instead of excel tables

What accounting software are you using? Xero

Hi @JSLINC

Thanks for using DataDear and for getting in touch.

Can you please clarify further, what is the use case for your request?

Regards,

David

Hello David,

I came across Data Dear through a referral, who asked me to check you out online,

I am looking to connect the data tables in my xero to my power bi desktop through your app, to carry out some advanced analysis,

Could your app enable me to connect to xero data tables through Powerbi?

If so, please can you send me a guidance note or please have a call with me to talk me through it please,

Thank you

Andrew

1 Like

Hi @andrew ,

Currently, we only have our Excel add-in available. You can connect Excel files or push data straight into Power BI super easily however we are looking to put a power BI connector in the market next year :slight_smile:

Regards,

David

1 Like

Hi Andrew,

I may be able to be of help here. as David has said Datadear is currently available as an Excel add-in, I have created solutions whereby your Datadear tables are saved in one Excel workbook this workbook is then queried using PowerQuery in Power Bi. As long as Power Bi knows where the Excel workbook is stored (either local or cloud) then I’ve found this solution works pretty flawlessly.

Cheers,

Tim

1 Like

Hello Tim,

Thank you for that insight, very helpful,

Best wishes
Andrew

Hi David,

Thank you for that,

Best wishes
Andrew

No problems Andrew happy to share how this works if it is of interest to you?

Dear Tim,

That would be really great, if you don’t mind,

Thank you so much,

Just let me know when you are free,

Best wishes
Andrew

Is this PowerBI connector in the market yet?

Hi @amir

Thank you for getting in touch.

There has been no PowerBI connector developed yet. However we have made a template available on the market place that allows user to run a DataDear report which feed into a custom made PowerBI dashboard.

image

Kind regards,

David

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.