Data source

[Anonymous]

Hello

Has anyone connected Power BI to GADD as a data source to make dashboards?

[v-luwang-msft · Accepted solution]

Hi @Anonymous ,

I think you need to do is to transferry files from folders to other folders on a regular daily basis.

Refer:

How to Automatically Move Files From One Folder to Another on Windows 10

Best Regards

Lucien

[Anonymous]

Thanks Lucien!

[v-luwang-msft]

Hi @Anonymous ,

In GADDxl the user clicks on “Export to Excel” and the data is automatically exported to Excel.
Query information and the data result are displayed in separate sheets. Pivot table and pivot chart are automatically created and can then be changed by the users.

Perhaps you can try exporting to excel and then importing to Power BI.

refer:https://www.gaddsoftware.com/white_papers/WP_GADD_Platform_Overview_2012-01-05.pdf 

Best Regards

Lucien

[Anonymous]

Hi Lucien

Thanks for the help. I am able to export the data as excel file. So I have a query that extracts me a excel file from GADD every morning but the problem is that every day the new file replaces the previous one as it has the same file name. But in my dashboard I need to have the previous data as well. Is there any way to have daily excel files in a folder with different file names so that the previous one is not replaced.

[Anonymous]

Hii

So I have some daily data coming out from GADD but I prefer to use Power BI to do the reporting. I would like to use the data coming out from GADD to make a dashboard using Power BI

[v-luwang-msft]

Hi @Anonymous ，

Referring to the official Microsoft article, there is no GADD in the data sources supported by Power BI.

REFER:

Power BI data sources

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[lbendlin]

That seems to make little sense. GADD is a reporting tool like Power BI. Why would you want to connect one reporting tool to another?