cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mannu Member
Member

Multiple Data Sources - You can't schedule refresh for this dataset because one or more sources

Hi,

 

I m unable to configure Data refresh using on-premises gateway in import mode. It shows the error message "You can't schedule refresh for this dataset because one or more sources currently don't support refresh".

 

It contains two data sources

 1. Excel Worksheet - placed locally (and on the server machine). Have tried working with Power Pivot as well as worksheet.

2. SAP BW Source

 

However excel sheets(files) are not displayed as part of data set when I try to configure data refresh for the same.

In fact I only see the error message stated above and do not see any other config options like Gateway, Schedule time ..etc.

 

 

Request your help at the earliest to resolve the issue.

 

Thanks,

Mannu

Mannu
1 ACCEPTED SOLUTION

Accepted Solutions
mannu Member
Member

Re: Multiple Data Sources - You can't schedule refresh for this dataset because one or more sources

Finally, I found the source of problem. When I compared PBIX of another data set that is currently configured for refresh with the new one, I found an additional parameter wrt SAP BW data source.  The additional parameter was not getting included in the previous versions of PBI Desktop.

 

I m not sure if this needs to be reported as a Bug. But I m sure that there hasn't been any changes to the SAP BW.

 

Bug_Found.png

 

Thanks,

Mannu

Mannu
3 REPLIES 3
Community Support Team
Community Support Team

Re: Multiple Data Sources - You can't schedule refresh for this dataset because one or more sources

Hi @mannu,

 

I can't reproduce your issue, can you share some detail information about this issue?

For e.g. how to import your excel worksheet, which gateway used to refresh, screenshots.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
mannu Member
Member

Re: Multiple Data Sources - You can't schedule refresh for this dataset because one or more sources

Hi Xiaoxin Sheng @v-shex-msft,

 

Thanks for your response.

I m using latest version of on-premises gateway (version 14.16.1639.1) on Windows Server 2012 R2.

and also the latest version of PBI Desktop (June 2017 update)

 

on-premises-gateway.PNG

PBI Desktop.PNG

 

A simple workbook on local machine, containing 2 worksheets is being imported into PBI Desktop (both worksheets are being used). No queries or connections are being made from within Excel work book.

 

WS1.PNGWS2.PNG

 

File.Contents is being used for both the worksheets and one of them is pasted below for reference.:

 

let
Source = Excel.Workbook(File.Contents("D:\Work\Power BI\AMI\Forecast.xlsx"), null, true),
#"FOR-Workdays_Sheet" = Source{[Item="FOR-Workdays",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"FOR-Workdays_Sheet", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", type date}, {"Calendar Date", type date}, {"Workday", Int64.Type}, {"Holiday", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Calendar Date", "Holiday"})
in
#"Removed Columns"

For SAP BW, similarly, it starts with

let
    Source = SapBusinessWarehouse.Cubes("10.92.64.117", "12", "110", [ScaleMeasures=false]),
    ZAMMI_M01 = Source{[Name="ZAMMI_M01"]}[Data],
    #"ZAMMI_M01/ZAMMI_M01_Q0001" = ZAMMI_M01{[Id="ZAMMI_M01/ZAMMI_M01_Q0001"]}[Data],

I have also tried clearing off the cache and all other data sources mentioned in  the file/ global permissions.

But still seeing the same error.

 

Thanks,

Mannu

Mannu
mannu Member
Member

Re: Multiple Data Sources - You can't schedule refresh for this dataset because one or more sources

Finally, I found the source of problem. When I compared PBIX of another data set that is currently configured for refresh with the new one, I found an additional parameter wrt SAP BW data source.  The additional parameter was not getting included in the previous versions of PBI Desktop.

 

I m not sure if this needs to be reported as a Bug. But I m sure that there hasn't been any changes to the SAP BW.

 

Bug_Found.png

 

Thanks,

Mannu

Mannu