Deployment pipeline problem

Question

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?

brunner_bi · Answer

Do you also have a pipeline for the datasets?

anonymous · Answer

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 · Answer

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 · Answer

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 --&gt; Data sources in current file --&gt; 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 · Answer

This is from Microsoft:"My visual broke after deploying a dataset or a dataflowCause: 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..

Forum Discussion

Deployment pipeline problem

6 Replies

Related content

Deployment Pipelines

Deployment Pipelines

Deployment Pipeline

Deployment Pipeline Error

Deployement Pipeline