Forum Discussion
Reproduce SSRS report as a Power BI report
there are a number of free courses on youtube on importing data into powerbi that will get you started
This is not a issue with importing data. Datasets and parameters for the SSRS report was created using stored procedures, UDFs, SQL codes and some objects from data sources. I want to use these elements to reproduce SSRS report as a Power BI report using Pober BI Desktop. In other words how can I take these objects to Power BI query editor to create those datasets to prepare a power BI data model and then reproduce it as a PBI report
we may be having an issue with terminology. A dataset or datasource in pbi is a set of tables with relationships that were built by importing data from servers and/or flat files probably using sql.
some stored procedures and udfs will be translated into custom columns in those tables if the values they hold are determined upon database refresh and not dynamically changed by filters and slicers. The languaged used to create these calculated fields is usually dax
dynamic results are gained through measures which are also written in dax.
finally these fields and measures are used in visuals to reproduce your report.
This is why I said you have to first look at the data you need to pull in so you can create a proper datasource. Then you look at the parameter driven data and dynamic data that you would need to render as measures.
as a former SSMS expert, I assure you that there is no simple route to becoming a power bi professional. No simple translation package you can use exists besides the tools that pbi provides, which are quite powerful.