I was looking for some direction and this gave me some ideas. What I ended up doing for this particular report was to schedule the Business Activity Query (BAQ) from Epicor to export to an .xml file and then use that file to create the Power BI Report.
The reason I did this was so that I could simplify the reporting process. Instead of recreating a dataset by importing all of the necessary tables and columns directly from the SQL DB, I instead just used the BAQ report that has been used to this point.
The current method for users was to run the BAQ, Export to Excel, modify and sort the information to their specifications, then create Pivot tables in order to see the data they way they wanted. This was a manual process that was performed several times per month.
Now, it is as simple as opening the report and clicking refresh. I present the results on Friday.
I will also (for testing purposes) be creating the same report with a SQL dataset. The challenge is getting the relationships correct. In this way, I can compare the data in both reports to verify whether or not my relationships are created correctly.
Thanks for the help.