Deployment pipeline: Visuals show no data when reports are deployed from DEV to TEST

[IP]

Dear community,

We are having a Deployment pipeline where we are using dataflows to implement reports.

When the solution is published to Power BI Service DEV workspace the reports are showing data but when I deploy the dataflow, datasets and reports to TEST workspace there is no data displayed.

Of course after the deployment from DEV to TEST I have configured the gateways and refreshed the dataflows and datasets.

Could you give me a hint what could be ?

Thank you in advance!

[rajibshovan]

In my case, dataset was required to refresh in Production env for the first time. Only deployment from Test to Production env ends up with no data in the Production enviroment.

[IP · Accepted solution]

Hi @Nimrod_Shalit 

Please find my answers below:

- can you check if after the refresh of the dataflow, it contains the data? - yes, contains data

- if the dataflow has data, is it passed into the dataset after you refresh it? - yes

- if the dataset has data and the report doesn't show it, can you check that the report is connected to that dataset? - yes

it can easily be checked by switching to lineage view in the workspace page.

It seems that now worked only after performing the below steps

1. unpublish the app

2. deleting all the dataflows, datasets and reports from TEST workspace

3. deploying again from DEV

4. refreshed the dataflows and datasets.

Before I was just doing the steps 2, 3 and 4 and didn't worked.

[LeeBenjamin]

Thanks @IP ! Let us know if it ever happends again.

BR,

Lee

[IP]

Hi @Nik ,

I have configured the rules and have redeployed from DEV to TEST and refresh the dataset in TEST again but still the visuals are empty.

On DEV and TEST we are using the same DB connection string and parameter values.

Do you have other idea ?

Thanks!

[Nimrod_Shalit]

@IP We need to understand the root cause of the problem to understand if it's a bug or anything else.

- can you check if after the refresh of the dataflow, it contains the data?

- if the dataflow has data, is it passed into the dataset after you refresh it?

- if the dataset has data and the report doesn't show it, can you check that the report is connected to that dataset? it can easily be checked by switching to lineage view in the workspace page.

Please provide screenshots of what you find.

[Anonymous]

Hi @IP 

After configuring the rules, please redeploy from DeV to Test and then refresh the dataset in Test env.