Changing Connection String with Import Mode
I have 20 or so Power BI Report Server reports all using ImportMode with SSAS(MD). I need to publish these to 6 different environments(all with different connection string’s) Looking for a couple of things 1)When will the ability to programmatically change the connection string for Import Mode, allowing for Data Refresh, be available. I realize you can do this for Direct Live but I need Import Mode https://docs.microsoft.com/en-us/power-bi/report-server/connect-data-source-apis 2)Until this ability exits what are potential work arounds…manually deploying 20 reports to six different environments is not that appealing to me. Thanks Mark Brodie
Powerbi reportserver is not show connection string and credential after restore
Hello , I use Powerbi report server on premise May 2019 version (window server 2012) on Production include 1 database server (sqlserver 2014 std) and 2 powerbi servers. I prepare the new cluster with backup restore reportserver and reportservertempdb database (sqlserver 2014 std) (backup from production) and config powerbi (May 2019 )to connect reportserver and reportservertempdb on new environment but when i connect new Powerbi web https://<PBIRS-servername>/reports/ and go to datasource . I found that Connection is not show connection string and credential are null even though production have connection string and credentials Have you found this issue or some case that's similar to my issue ? would you please help? thank you, Peach
Prevent Datasource connection from being overwritten on PBIX upload
Not sure if I'm missing something but we have 3 environemnts a Dev/UAT/Prod environment of PBIRS and each has their own SSAS instance to point to. We upload our PBIX files to each environment as and when we have changes to be published. Every time we upload though we either have to change the connection in the PBIX before uploading or change it in the PBIRS datasource after uploading which is cumbersome. Is there a way to upload or publish without the connection string getting overwritten so that once it is set in each environment, it doesn't change.Change connectionstring from tenant
Hi all, Currently we are working on a migration of Power BI from Office 365 tenant A to Office 365 tenant B. Datasets that resides within Office 365 tenant A will be moved to tenant B. So far so good, but there are several Excel reports that are connected to Power BI datasets. Is there a way to change the connection string of the Excel reports so we can change the source from the dataset from tenant A to tenant B? We do not want to recreate the reports and ofcourse the datasets are exactly the same within tenant A and tenant B.
