BUG - Sample File Generated in Desktop creates Failure in Service

[compscinj]

I created a report from files I had on my local machine. After ensuring it worked properly, I moved the data source to a network location. However, the sample file that generates to tell Power BI how to view the rest of the files was still looking on my local machine. When I uploaded this to the Power BI Service, I did not get any errors saying a data source was missing (this missing data source being my machine). However, when I tried to use my Enterprise Gateway with the dataset for the report (Network location) it kept crashing. Fixed this by going to my sample file and making it also point to the network location, but I had to do that manually. 

[v-qiuyu-msft]

Hi @compscinj,

As the report get data from local files originally, after you move the local files to network location, the files path will not be changed to the new path automatically, when you refresh the report in Power BI desktop, it will be failed. 

You need to edit file path via Data Source Settings in Power BI desktop to make sure the report can be refreshed successfully in Power BI desktop firstly. after you publish the report to Power BI service, you need to create a data source points to to the network location in data gateway, then configure the dataset to use this data gateway ( the data source connection information created in data gateway needs to match the path information used in dataset completely). 

Best Regards,
Qiuyun Yu 

[compscinj]

Hi @v-qiuyu-msft,

I did edit the data source settings, but that is not where I am saying the bug is. The sample query that Power BI creates did not automatically change its data source to the network location even after I changed the data source setting for my queries. I was able to figure this out eventually and change the sample query, but some users might not look at the sample query since they did not create it. The fix I a suggesting is that if a sample query is created, Power BI Desktop should change its data source automatically if the query it is setup to support changes its data source. 

[v-qiuyu-msft]

Hi @compscinj,

I know what you want, but Power BI will not change the data source automatically if you move the source to different location. It will get data from data source based on which information you specified in Data source Settings wherever you move the data source to anywhere. 

Best Regards,
Qiuyun Yu