Forum Discussion
Periodically converting external data to a standard format - is Power BI the right tool for the job?
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 f...
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
Hi Anonymous
Thanks for your reply. Do you know of another tool which would suit my needs?
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
