Editing a published dataset (SQL)

Hi, We currently have a dataset published in the PBI service that sources data from multiple tables in Azure Postgre via SQL. This dataset is used across multiple reports as well. There now exists ...

Need Help

ibarrau
5 years ago
Hi. You should take the dataset.pbix and edit it with Power Bi Desktop. Change the query and publish replacing the one in Service. That way the dataset will take the change in SQL for all reports connected to that one.

It's a good idea to keep versioning of the dataset. You can save it in sharepoint in order to keep the changes you make like this one versioned. to roll back things.

Hope that make sense.