SSAS Tabular Data Sources and Deploying

Question

Hi Looking for any info...

I am using VS 2019 to create a tabular model in a Development domain. I am deploying to a "Test" domain by handing off my files from the BIN folder (after a build) to the dba. Not sure what method this is technically.

My data source is Oracle and I am writing sql queries to act as dims and facts tables.

First, What is the best way to connect to Oracle using sql queries? I right click data sources and I can only see tables. Where can I enter my query? I didn't see blank query in my data sources. Can I update the name? Why is the name greyed out? Looking for the best methodology.

Second, I need a methodology for deploying to Prod. How can I update my tables to use a different data source? Can I script a data source and run in Visual Studio? I thought this was in configurations... but having trouble finding.

Thanks guys! I know I asked allot of questions any help or links appreciated.

Mike

Answer 1

Really Id just like to know if you can edit or change a data source name

Answer 2

You can select one table, then click Transform Data... When you get into Power Query Editor, use the Query menu to create a Blank Query ![35523-image.png][1] [1]: /api/attachments/35523-image.png?platform=QnA

Answer 3

Hi,

Did you mean table name or datasource name?
If it is table name , you could change it here
Or in the query editor , when you click transform data.

Second, I need a methodology for deploying to Prod. How can I update my tables to use a different data source?

For this you could click the table property for datasource, change it in the editor .(It uses M query to run)
See example:

You could google M query, your most request could be met by modifying the M.

Regards,
Lukas

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.