‘ Removed Other Columns’ query line) from Advanced Editor So, we just need modify that particular remove columns query line (i.e.
Then, select query from data source queries and click on ‘ Advanced Editor’ Button as shown below.
After that you will be redirected to the new window, which will show you the data sources of your Power BI report.Ĥ. Then, click on ‘ Edit Queries’ button to edit data source query as highlighted below.ģ. Note: Power BI report name must be unique.Ģ. Make a copy of Power BI report created for Sandbox environment and rename it. To do the same follow the steps given below:ġ. Now, we want to execute same report for the Production environment. In the following case, we have added Account and Contact entity data for the Sandbox environment from Common Data Service using ‘ Get Data’ button. Now let’s have a look into the steps to change Data Source using Advanced Editor. After a thorough search, it was found that we can customize the report data source and data source queries using Advanced Editor. But in our case the ‘ Change Source’ button was not enabled and we were not able to change the data source of the Power BI report using ‘ Change Source’ button. Usually, we change the report data source from ‘ Data Source Setting’ as there is a ‘ Change Source’ Button available to change the report data source. And after creating the report we wanted to execute the same report for Production environment. So we created the Power BI report for Sandbox environment.
Recently, we had a business requirement to create Power BI report. $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5') Header('Content-Disposition: attachment filename="results.xls"') Header('Content-Type: application/vnd.ms-excel') Redirect output to a client’s web browser (Excel5) start of printing column names as names of MySQL fieldsįor ($i = 1 $i getActiveSheet()->setCellValue($column.$rowCount, mysql_field_name($result,$i)) įor($j=1 $jgetActiveSheet()->setCellValue($column.$rowCount, $value) Set the active Excel worksheet to sheet 0