Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
IP
Frequent Visitor

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

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!

1 ACCEPTED SOLUTION
IP
Frequent Visitor

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.

IP_0-1655926169323.png

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.

 

View solution in original post

6 REPLIES 6
rajibshovan
Frequent Visitor

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
Frequent Visitor

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.

IP_0-1655926169323.png

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
Microsoft Employee
Microsoft Employee

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

BR,

Lee

IP
Frequent Visitor

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!

@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
Not applicable

Hi @IP 

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

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.