topic Re: Replace Data Source in Developer

Replace Data Source

Kap — Sun, 17 Apr 2016 07:43:08 GMT

Hi.

I have built visualizations in power bi using excel files as source.

Now i have to connect that to Azure SQL datawarehouse, but my visualizations should be intact. It means just replace excel file to Azure data warehouse keeping everything same at visualization level.

Please let me know the steps how to do this.

Re: Replace Data Source

Anonymous — Mon, 18 Apr 2016 16:41:24 GMT

That seems to be a common scenario, I am about to face a similar case with shifting from one database to the other (one staging environment to another staging environment, then eventually production). Is there a way to simple replace the connection string or something like that?

Re: Replace Data Source

Jeromebx — Tue, 05 Jul 2016 09:54:48 GMT

I have the same requirement and no documentation can be found on this.

Has anybody succeeded to achieve this?

Re: Replace Data Source

jocaplan-MSFT — Tue, 05 Jul 2016 19:49:34 GMT

We support this currently for direct query sources only: https://msdn.microsoft.com/en-us/library/mt711505.aspx. We are working on adding this to other types of sources as well.

Re: Replace Data Source

Jeromebx — Thu, 07 Jul 2016 17:05:47 GMT

I made the test with an "Direct Query" report and replaced tthe datasource to the actual "Azure SQL Database" but get an error

Code d'erreurDMTS_NoGatewayWithAllDatasourcesToBindError

Serverserverdbjoss.database.windows.net

There is no more information that that and I have no clue of what could be the preblem.

I have made a check that the SQL datbase was aceessible from Azure Cloud usign a test program on the serveer.

So the problem really seems to be with PBI Emebedded to get acess to the SQL database.

I miss information to understand the root cause of the problem (the Azure PBI admin console if not really usefull as DataSources are not visible).

Any help?

Re: Replace Data Source

jocaplan-MSFT — Fri, 08 Jul 2016 22:46:42 GMT

That's odd. The error makes it sound like you have more than one data source in that file. Can you please confirm that you only have 1? It can vary by table.

Re: Replace Data Source

Jeromebx — Mon, 11 Jul 2016 07:52:04 GMT

I confirm I have only 1 datasource.

I managed to get a configuration working starting from a report using an SQL Database. I was able to update the datasource of the PBI Embedded report.

My testing so far:

Report using an Oracle /mysql data source: update of data source in workspace to use SQL Azure fails
Report using an Azure data source l data source: update of data source is successfull (update of credentials

I suspect the error occurs when the initial data source provider is different that the target one (Azure SQL)