From reading the docs on powerbi_pbix, my expectation was that I would be I would be able to use for example the original_database abd database fields in order to point my report to a different DB from the one that was used to develop the PBIX file.
In other words:
A dev creates a report using some kind of "dev" database for source data. Once ready, export the pbix file
For prod, we deploy that pbix file, but swap out the database for the source data.
Something like:
{
original_database = "dev"
database = "prod"
}
My assumption was that this would create a new dataset, this time sourced from the "prod" database instead. But I am fairly certain I am missing something, since whatever I try, I get the following error:
│ Error: Post "https://api.powerbi.com/v1.0/myorg/groups/xxxxxx/datasets/xxxxxxxxx/Default.UpdateDatasources": status code '404 Not Found' with body {"error":{"code":"ItemNotFound","message":"Dataset doesn't contain a datasource that matches selector #1"}}
│
│ with module.powerbi_reports.powerbi_pbix.example,
│ on modules/powerbi_reports/main.tf line 1, in resource "powerbi_pbix" "example":
│ 1: resource "powerbi_pbix" "example" {
│
I would be great if the docs could be updated to clearly explain how to use this feature
From reading the docs on
powerbi_pbix, my expectation was that I would be I would be able to use for example theoriginal_databaseabddatabasefields in order to point my report to a different DB from the one that was used to develop the PBIX file.In other words:
Something like:
My assumption was that this would create a new dataset, this time sourced from the "prod" database instead. But I am fairly certain I am missing something, since whatever I try, I get the following error:
I would be great if the docs could be updated to clearly explain how to use this feature