Forum Discussion
Using Data Sources in PowerBI Report Server (August Preview)
Hi, I have set up a Data Source on the PowerBI Server, it is a "Microsoft SQL Server" connection type, connecting to a SQL Server database. It connect successfully. How do I use this Data Source in ...
Hi Anonymous,
The data source which you created in Power BI report server is not used by Power BI report. It's a shared data source which can be used by SSRS paginated reports and mobiles reports.
To create a Power BI report, we need to connect to SQL Server data source inside of the Power BI desktop by Get Data.
Best Regards,
Qiuyun Yu
So, every time I want to deploy the PBIX to a different environment, I need to open it from PBI Desktop from within that environment and change the queries? That is really poor. I do not understand why I cannot change the connection string from within Report Manager just as I can for the .rdl files.