Forum Discussion
Create table based on certain columns from different Excel-sheets
Hi Anonymous ,
Based on your description, I think creating a template is worth considering:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-templates
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Solution SageHi Xilitor,
I'm not a 100% sure if this is what you are looking for but it is possible to append the different tables into one in power query, so that you can visualize all columns in the same visual. Depending on which columns are filled for each company, it will return either a filled or empty value.
Best regards,
Tim
Thank you for your response, Tim!
I might've been unclear - I get your suggestion though.
The problem is that only one Excel-sheet should be used at a time as each Excel-sheet present a company and they should not get information about other companies.
I hope that makes sense.
Thank you anyway 🙂
- timg
Ahh oke,
So do I understand correctly that you only want to connect to one sheet/company. And then be able to change the connection to a different sheet/company while not having to change the queries or visuals?
In that case, would it be possible to standardize the layout of the excel files so that they all have the same columns e.g. like your example table above, that all sheets contain column 1 to 10. They do not all need to be filled, but as long as the column definition is the same you could then switch the excel sheet (manually in the data source or via a parameter) without having to make any changes in the queries. This way, you could make one visual with all columns, and depending on which sheet you connect to it will display the relevant columns filled.
Regards,
Tim
Yes you understand it correctly now! I don't have the opportunity to ensure that the Excel-sheet includes all the columns. It is an extract from SAP ERP.
I thought it'd be possible to create an IF statement like "If these columns are in the dataset then insert them in the table and if not then forget about them".
Thank you so much for taking your time, Tim - Really appreciated! 🙂