Forum Discussion
Process dataset clear
It's not a template. It's the dataset . The datasets are used in active development.
Rather than having the datasets in current development stored on a drive on someones PC they need to be in source control. However source control has limitations with processing big files.
I need a way of storing the pbix files for traceability and reusability.
Ok... still not seeing why a template file wouldn't work for this.
The template stores all the query definitions, relationships, calculations, etc. Everything except the data itself, which is exactly what you requested.
Create dataset, deploy to development workspace
Convert to template.
Template saved to source control.
template deployed to test?
template deployed to uat?
changes made to template.
template deployed to dev?
See what I'm getting at?, I need to pick it up and still develop off it.
I want to store the pbix file as that is what is developed off and that is what is deployed for the reports to use.
How do I carry out development changes on the template and how do I deploy the template as a dataset? Simly answer is you can't, you have to then convert it which means which you are storing in source control is different to what you are deploying.
Another way to think of it is:
I want to be able to save and deploy Power BI datasets and reports just like you would any other database object or Azure resource.
Have the code base in GIT. Azure DevOps picks it up and deploys it across environments.
That would mean having the dataset in the apropiate format which is is developed and needs to be deployed.