Data Source Excel Sheet

[TheRevenant]

Unfortunately I cannot connect PowerBI to Salesforce and I will need to generate reporting in PowerBI from the exports in Salesforce which are in Excel.

Do you recommend creating an Excel template for which you copy and paste the data into so automatically generate in PowerBI?

Or can you load the Excel sheet directly into PowerBI and structure the data within PowerBI?

Thanks

 

[TheRevenant]

Power Query