PowerQuery (in Excel) moved into PowerBI

[tazeo]

I have a workbook in which a series of queries are written, each of them performing different tasks using the data from a separate workbook.

After researching various YouTube videos and threads from this forum and others, it has become apparent that using PowerBI will result in improved outputs.

I have seen a lot of information suggesting that I can use Excel created queries in PowerBI, yet none of the examples that I have attempted to follow have functioned correctly.

Are there any instructions anyone could give me, or point me in the right direction for finding them?
OR
Should I start over from the beginning in PowerBI?

 

[jdellasala]

If by saying using PowerBI will result in improved outputs you mean more complex and interactive elements that can be published and used by anyone with access to the server on any device, you're correct. However, unless you have access to a Power BI server, your options are limited to creating a presentation in Power BI Desktop and distributing or sharing that file and possibly all its subsidiary data sources. It should be noted that Excel Online is starting to acquire Power Query, and you might be better off using it if you're sharing your work without access to a Power BI server. If you don't have access to a Power BI Server and aren't using the licensed version of Power BI, unfortunately it doesn't show up in the online office.com apps.

That said, although there is a way to export Excel Power Query queries that can then be shared with others, Power BI cannot import those files (which I don't understand!). In Excel they are saved to the My Data Sources folder by default whose location may vary depending on whether or not you use One Drive.

Importing the Excel file doesn't help either. The Queries themselves don't come in.

Your only option is to open the query in the Advanced Editor, copy the code for the entire query and paste it into a text file, and then open a blank query in Power BI and paste the code into the Advanced Editor there.

 

[tazeo]

Thanks, sort of what I thought. I will try your solution.
For clarity, my thinking was the report/dashboard creation was going to be easier/better/streamlined (any similar words) using PowerBI. I do have access to server but am working my way up to that