Frequent Visitor
Posts: 2
Registered: ‎06-08-2017

Use three spreadsheet for report

How can I use three different Excel spreadsheet to create one Power Bi report?

Frequent Visitor
Posts: 3
Registered: ‎04-02-2017

Re: Use three spreadsheet for report

You can create one Power BI Report with your three different excel spreadsheets. Once you have imported the excel spreadsheets, create a relationships if exists for those. If not, still it is possible to do the report but you need to careful while creating visuals and it will make nonsense if you drag non-related fields onto the canvas.


Cheers !!