Solved: Using a report for multiple dataset

Anonymous · ‎02-18-2019

I have a database that will have stardand data fields names and will be clone for new users and possible have different columns name but the same structure. I want to be able to create a template of a report and then use this template for a new dataset connected to the database. To clairfy I have will have db1 connect via dataset connected to a workspace on powerbi.com, I will create a new db2, simliar to db1, that will be connected to a new workspace but will use a report from db1, I need to be able to move the report template over and use it on db2 dataset with out having to create a new report.

Anonymous · ‎03-07-2019

So the fix to this problem is you can use the parameters and a if statement in the power Query to call different SQL queries. All of the columns names need to be the same name in the SQL queries e.g if one database has firstname another have namefirst then you would write Select firstname as 'first' from... and Slect namefirst as 'first' from ... (It does not matter the name in the query). After which you can change the name of the column via power query.

View solution in original post

Anonymous · ‎03-07-2019

So the fix to this problem is you can use the parameters and a if statement in the power Query to call different SQL queries. All of the columns names need to be the same name in the SQL queries e.g if one database has firstname another have namefirst then you would write Select firstname as 'first' from... and Slect namefirst as 'first' from ... (It does not matter the name in the query). After which you can change the name of the column via power query.