Couple of things...

First, PBI can read from many data sources (including SQL server).

Second, it's more important to identify what you would show in a dashboard. You can build a good dashboard in a shared Excel sheet or an SSRS report, and a really crappy dashboard using PBI.

Dashboards are about (among other things) surfacing business anomalies/major items of interest.....for instance, a product cost/price jumping up 15% in one market from last month to this month (while other markets stayed constant).....

Many moons ago I did some work for Apress and sat in on their sales calls....want to know the first topic every week? Returns. That was a major topic.
In the world of manufacturing, it's things like damages and scrap.....finding the data that represents the the worst things that hurt a business (or best things that help, depending on the focus)

As much as I love PBI and SSRS....don't worry so much about the tool....focus on what things you can surface to the business in the course of the day/week/month that they might not always be aware of.