How to create Power BI Data Model Automatically using power shell

[y08it105]

Hi Team,

How do we extract the json code behind the power bi Model and use that to create a new power bi model by changing the table names and relation ship using power shell.

Thanks,

Manoj

[y08it105]

I am accepting this is a solution. However we have sent a note Microsoft team to understand further

[GilbertQ]

Thanks for letting us know.

[GilbertQ]

Hi @y08it105 

The push dataset is where it just has got one table and then you can view this via a dashboard. This would not create a robuts and scalable dataset for reporting.

[y08it105]

 Hi @GilbertQ , Looks like we have a way using Push Data Set API, but mircosoft or power bi didn't implement the completly, i am able to create data sets automatically but not able to data source connection and relationships 

Below is the link i am using 

https://docs.microsoft.com/en-us/rest/api/power-bi/push-datasets/datasets-post-dataset

[GilbertQ · Accepted solution]

Hi @y08it105 

As far as I know this is not possible, you would need to try and use Tabular Editor which might be the only way to get this working. Just note that it is not fully supported.