cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

You can't schedule refresh for this dataset because one or more sources currently don't support

Hi,

 

I m importing data from an Excel Worksheet and 1 SAP BW data source as in snapshot below 

E3.PNG

While there is no problem working with report in PBI Desktop, I m unable to schedule refresh using on-premises gateway. The excel files are available on the server machine in the required path and are configured as data sources on the server.

But seeing the error message as being displayed below. If I use only one of the two sources, I m able to refresh them.

 

E1.PNGE4.PNGE2.png

 

How can I combine the data from multiple data sources within the same data set and still enable data refresh?

 

Request your help at the earliest

 

Thanks,

Mannu

Mannu
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver I
Resolver I

Re: You can't schedule refresh for this dataset because one or more sources currently don't support

Found the resolution for the issue. When I imported data from SAP BW, it included an additional parameter ScalarMeasure=False which I found via Advanced Editor (and which was not provided from interface). Removing this parameter resolved the issue.
Mannu

View solution in original post

5 REPLIES 5
Highlighted
Continued Contributor
Continued Contributor

Re: You can't schedule refresh for this dataset because one or more sources currently don't support

It looks like SAP BW isn't supported by the On-Premises Data Gateway.

Highlighted
Resolver I
Resolver I

Re: You can't schedule refresh for this dataset because one or more sources currently don't support

@wonga SAP BW is supported for data refresh using On-Premises gateway. Infact Im using the same SAP BW Server for another data set and scheduled refresh works fine. But it contains data from a single source (SAP BW).

 

SAP BW Schedule Succeeds.PNG

 

Similarly, I tried to configure data refresh for dataset that contains only excel worksheet. This also works !!! 

 Its only when I import data from both excel and SAP BW to a single data set, that I m unable to configure data refresh.

Mannu
Highlighted
Microsoft
Microsoft

Re: You can't schedule refresh for this dataset because one or more sources currently don't support

@mannu,

Do you connect to other data sources in the Excel file? Could you please share me the Excel file so that I can test? Besides, please go to File -> Options and settings ->Data source settings to check data sources, then post a screenshot about the data sources.


Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Resolver I
Resolver I

Re: You can't schedule refresh for this dataset because one or more sources currently don't support

Hi @v-yuezhe-msft

 

Thanks for your response.

 

No. There are no connections within the excel. I created a new workbook/worksheet and pasted the table provided below.

Connected to SAP BW server and pulled in another 2-3 columns info from BeX query and then tried to publish the report.

 

I also tried adding it to Model using Power Pivot and checked if it works.

Result was the same.

I have placed the excel in the same path on Server machine (where on-premises gateway is installed) .

 

NameAmountCountry
A127842US
A282117CA
A357567MX
A415345US
A568867CA
A689570US
A712132CA
A898666MX

 

 

DS_CurrentFile.PNGDS_Global.PNG

 

Thanks & Regards,

Mannu

Mannu
Highlighted
Resolver I
Resolver I

Re: You can't schedule refresh for this dataset because one or more sources currently don't support

Found the resolution for the issue. When I imported data from SAP BW, it included an additional parameter ScalarMeasure=False which I found via Advanced Editor (and which was not provided from interface). Removing this parameter resolved the issue.
Mannu

View solution in original post

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors