Is there a way to Connect to Jira and create our own dashboards using PowerBI Desktop only,
Welcome to the Atlassian Community!
I'd strongly recommend getting one of the Power BI connector apps from the marketplace. These avoid you having to read and understand the database (it's terrible for reporting and trying to do it yourself is a LOT of work)