I have a report with two data sources from Excel files. I also installed a Gateway on my local computer, and want to start using it, with a scheduled refresh.
At first, I've created two data sources on the gateway. Both of them have the same paths as in my Desktop report.
When I publish it to app.powerbi.com it worked well.
But after that, I wanted to have different data sources for Development and Quality Check reports.
So I created a parameter with a list of two values: "DEV' ad "QA".
And then I edited my data sources definition and append it to file names. I also added this sufixes to files on disk.
So now when I change the parameter, I'm changing file which I'm using. It is working on Desktop well.
After that, on the gateway, I've created new data sources - for each Excel two for DEV and QA. And again the path to files was the same. And it worked.
But I want to have those Excel files in separate directories. I also thought that only file name should match, so I removed that data sources from the gateway and created a new one with paths different from that form Desktop.
And after that I'm seeing that warning at app.powerbi.com:
You don't have any gateway installed or configured for the data sources in this dataset. Please install a new personal gateway or configure the data source for an existing data gateway.
So in my report, I've selected "Enter Data" and created a table with two columns: Parameter and Base Path. Base Path contains a full path to the directory where Excel files for the environment are located. I also created the function which returns me a path based on current value of environment parameter.
After that, I changed my data sources and they are loading Excel in this way:
Source = Excel.Workbook(File.Contents(GetBaseFolder() & "MyTestFile.xlsx"), null, true)
So I thought that with this solution, my file names can be the same but they can be placed in different directories, which I can read by my function. But after publishing that report to app.powerbi.com I'm getting:
You can't schedule refresh for this dataset because one or more sources currently don't support refresh.
It's very weird, I don't know what I changed. I also made a version which adds a suffix to file name, so they could be distinguished between environments, but it didn't work.
Also, all paths produced by concatenation base directory and file name are the same as in data source configuration.
Can anybody help me?
Marcin
