Forum Discussion
Solved
Reports Datasets
When we create reports in Power BI we use TSQL and also M. One of the situations we are facing is how to know which tables/objects are being used on each report. From time to time there are changes ...
jotaandres I've used both. As long as you have a way to create a layer between the code and the output you put yourself in a much better position to make these types of changes without impacting your front end reporting significantly.
jotaandres First, I would recommend you start using views, that way you can make your changes and there will be no impact to the Power BI reports.
Second, the only way you are likely to get close to this would be using the APIs or Cmdlets... this blog may help.