search

microsoft / RdlMigration

Tool that converts RDL from a SQL Server Reporting Services Server or Power BI Report server and published to a Power BI premium workspace
MIT License
111 stars 44 forks source link

Shared Data Source Conversion with No Server Mapping or Database Service Entry #25

Open nicdiver opened 4 years ago

nicdiver commented 4 years ago

Hello,

What we are trying to do: Convert shared data sources that point to an oracle database into embedded data sources

Issues:

  1. Our SSRS reports have a TNS entry only (service is defined in tnsnames.ora). Power BI Gateway sources must have an entry for identifying the TNS entry and the service name so upon conversion the data source is not usable in the Power BI Service.
  2. After report conversion and upload even if the server entries match it does not map to that gateway entry

I can fix issues 1, 2 manually but we have 1000+ so that is not really viable.

It would be ideal if...

  1. For a given TNS entry the service name could be derived from tnsnames.ora or perhaps even better a default service name.
  2. When "servers" match, auto map an uploaded report with it's matching gateway entry. In the case of multiple matching "servers" then skip?

Kind regards,

Lyle Spencer Gonzaga University