Periodically converting external data to a standard format - is Power BI the right tool for the job?

[JCK]

Our business gets sent price lists from multiple suppliers - each in their own format. I am attempting to create an automated way to bring these price lists in a standard format. This will then get fed into our internal systems (accounting/stock keeping/ecommerce).

Providing each supplier sticks to their format, is Power BI the right tool to manipulate this data and spit out a required file(s) when it's sent? The file needed to be exported would be a CSV/Excel file. I would imagine each supplier would have their own profile. 

I have been trying to learn Power BI to figure out if it's correct, but I am not 100% sure it's the right tool. I am not sure I can save the "profile" and just apply it every time we get sent an updated price list file from the supplier. It seems more that it's constantly fetching data from a data source.

I'd really love any input on this. If Power BI is not the right tool, is there another one, or would I need to hire a developer to do the data manipulation?

Thanks

[v-shex-msft]

HI @JCK,

Based on your description, I think power bi not fully suitable for your requirement. Power bi is a reporting tool which suitable for get data from different type of data sources and create visualizations.

In my opinion, I don't think it will be suitable to convert/transfer/encode different format records to standard format.

Regards,

Xiaoxin Sheng

[JCK]

Hi @v-shex-msft

Thanks for your reply. Do you know of another tool which would suit my needs?

[v-shex-msft]

HI @JCK,

Maybe you can ask programmer to create a data convert/format interface to receive data and return formatted table.(most of programming languages all suitable for data convert)

After these steps, you only need to get data from that interface/api.

Regards,

Xiaoxin Sheng