Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
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.
Thanks,
Mannu
Hi @Anonymous,
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
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)
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.
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
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.
Thanks,
Mannu
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.