Objective
Extract the metadata from a tabular model using a PowerShell script and SQL Server 2016. In this section, we are going to extract the list of Tabular relationships and their corresponding metadata.
Requirements
Please see the requirements listed here: Document and Track changes in your Tabular Model
Steps
If you do not want to store metadata in a separate database, please proceed to step 3.
- Download the script file: 0335 Relationship.sql
- Run the script in SSMS.
- Download the PowerShell script: 335--Relationship.ps1.
- Use PowerShell ISE (or other PowerShell tool) to open the PowerShell file.
- Set the parameters in the PowerShell script to align with your environment (see Requirements).
- This script can either display the information or populate the table created in the step above.
- Run the PowerShell script (generally I use a *.bat file to load all of my PowerShell scripts)
Hello! Do check the link for amazing offers, also thanks for sharing the amazing content.
ReplyDeleteBusiness Intelligence Consultant
Business Intelligence consulting Services
Thankyou for sharing Business Intelligence Service Providers India
ReplyDelete