Deployment pipeline problem

[Anonymous]

Hi, I need a quick help with a problem, please.

My report (from desktop) works good in development, but when I deploy it to test (and prod) it doesn't work. Visualizations doesn't show data, and there are just the titles of data tables but not any data in.

I am not be able to create gateways. How can I get my deployment pipeline's test and production works as well?

Data comes from SharePoint list (company.sharepoint.com/sites/folder).

What can I do?

[Anonymous]

Okay, now it goes to more interesting.

I deployed once again and refreshed data in TEST, now data shows there. But still report doesn't work (visualizations doesn't work as they need to and as they do in dev). I downloaded report again and now it gives ""There are pending changes in your queries that haven't been applied. [Apply changes] [Discard changes]". And if I apply, report brokes (every visualizations falls). And then there is not any data in whole report.
Otherwise if I click Discard, it asks "Discard your changes? You've changed:
- 1st table

- 2nd table

- 3rd table

etc. (there is more tables than I have in this report). And if I click Discard, it seems report works as it should.

Could someone please help me out 😄

[Brunner_BI]

Do you also have a pipeline for the datasets?

[Anonymous]

What? Different one? No. I have always done just one pipeline (which have reports and data). But this is my first time to use sharepoint list as data source..

This pipeline is something where i had a previous report also (to the same customer) so I thought it eould be great to use it. But then this problem appears..

[Brunner_BI]

To try to debug it, download the report that is broken (the one in TEST, right?) and see if anything changed in the data sources / which dataset it is connected to and see exactly what is broken. Then you will find out what happened.

[Anonymous]

Hi, thank you for your response.

When I download Test version, it gives me three warnings/errors:

"There are pending changes in your queries that haven't been applied. [Apply changes] [Discard changes]"
"One or more calculated objects need to be manually refreshed [Refresh now]"
"Some of the tables have incomplete or no data. [Refresh now]"

And when I go to Data source settings --> Data sources in current file --> There is not any data sources.. "We didn't find any data sources in this file."

But this is the problem; WHY my data does not move from dev to test when I deploy it? Normally it does (when using excel, web (sharepoint) etc.)

[Anonymous]

This is from Microsoft:

"My visual broke after deploying a dataset or a dataflow
Cause: Datasets and dataflows are Fabric items that store data and contain both data and metadata. During deployment, only the metadata is copied while the data isn't. As a result, after deployment the dataset or dataflow might not have any data and a report visual that's relying on this data, will appear broken.
Solution: To solve this problem, refresh the dataflow and then refresh the dataset in the target stage."

But this solution also has just "create a gateway" as many same problem's solutions in BI community does as well. But unfortunately it is not solution in my case 😕 So need something else to fix it..