Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Showing the data through power BI using few SQL data tables

Hi,

 

I'm just beginning using PowerBI and was wondering is it possible to show me the data I need.

 

I have 2 SQL tables:

 

So as you can see 1st table contains ALL UK companies with: Number, Postcode and it's incorporation date.

2nd table contains all UK postcodes and Local Authority name it belongs to like London, Manchester, Liverpool etc. For this example we need just one so I've picked london.

 

Now the task is to get the data about all the companies created within specific time period for ex:

"Show me all the companies created in London between 06-2008 and 12-2012.

 

Is it possible to use power BI to show this data?

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    Anonymous this should be relatively simple.

    Create a 1-many relationship between "All_Luton_Postcodes" and "BasicCompanyData" on the PostCode→RegAddress_PostCode.

    Then in the report, use a date slicer on "Incorporation Date" to filter by the dates desired, and a slicer on "LocalAuthrityName" to filter to the locale desired.  Then add a table or matrix visual showing the desired information (CompanyNumber, IncorporationDate, Postal Code, etc.)

     

5 Replies