Forum Discussion
PowerBI Gateway Datasource
Hi Lex,
You can't select the same Gateway for the Report B even though the data source had been added when you created Report A. Is this the scenario?
As we can see from the snapshot below, a data source of a Gateway only needs Server and Database. So the possible cause could be the Server name are different. For example, "localhost" in the Gateway while "ServerName" in the dataset. Please check out.
Best Regards,
Dale
Hi Dale,
Sorry, it is difficult for me to explain.
I have made report A in Power BI Desktop.
The datasource in this report is SQL Server X and database 1.
From database 1 I have selected a table 1A
I have published this report A and connected it in Power BI Service to a datasource (Data source type: SQL server, Server X and Database 1) of the gateway.
Daily refresh of this report is working correctly.
So far so good.
Report B (als made in Power BI Desktop).
Datasource in this report is the same as report A (SQL Server X and database 1).
From database 1 I have selected table 1B.
I have published this report also.
In Power BI Service I want to connect this report to the same datasource in the gateway as above: Data source type: SQL server, Server X and Database 1
And this is not possible. Why not?
With regards
Lex
Hi Lex,
You can't select the same Gateway for the Report B even though the data source had been added when you created Report A. Is this the scenario?
As we can see from the snapshot below, a data source of a Gateway only needs Server and Database. So the possible cause could be the Server name are different. For example, "localhost" in the Gateway while "ServerName" in the dataset. Please check out.
Best Regards,
Dale