4 years ago, we had to customize the xer parser for a client, that work end up as Xer Reader, turn out the file was very popular, but unfortunately, as it was written in VBA, users get all kind of different errors, and I was not able to provide a proper support.
now I am trying to rewrite the same Excel Macro but now using PowerBI, the file is hosted in github
in order to open a pbix file, you need PowerBI Desktop, it is a free download
I think it will be an interesting experience, some stuff are much easier using VBA, and there is no equivalent in PowerBI, I will try to document the progress.
in the main time here is my progress so far
3 thoughts on “Rewriting Xer Reader using PowerBI”
thanks for your effort of integrating the P6 Schema using Query to PBI. Looking good and keep it up the good work. Is it WIP and what’s the difference compare to the older version?
it is totally different, you can download PowerBI desktop and test it for yourself, and tell me if it works for you
XER file as the only source? your query is still referencing/using the SQL light. Thank you!