Can't Refresh this dataset - Simple SQL dataset

[daniBBB]

Hi

After updating my report, deleting the old one and publishing a new one, I am now getting the following error.

I was able to connect to this data source before, and I still can if I upload the original report without changes.

The data source is a local SQL database which I connect to via a gateway.

You can't schedule refresh for this dataset because the following data sources currently don't support refresh:
Data source for Query1
Discover Data Sources
FindReferencedDataSources with exception System.NotSupportedException: The given data source kind is not supported. Data source kind: UnknownFunction. at Microsoft.Data.Mashup.DataSourceReference..ctor(IDataSourceLocation dataSourceLocation) at Microsoft.Data.Mashup.DataSourceDiscoveryVisitor.CreateDataSource(String dataSourceFunctionName, IExpression expression) at Microsoft.Data.Mashup.DataSourceDiscoveryVisitor.SafeCreateDataSource(String dataSourceFunctionName, IExpression expression) at Microsoft.Data.Mashup.DataSourceDiscoveryVisitor.AnalyzeInvocation(IInvocationExpression invocation, Boolean& isDatabaseFunction, IInvocationExpression& resolved) at Microsoft.Data.Mashup.DataSourceDiscoveryVisitor.VisitInvocation(IInvocationExpression invocation) at Microsoft.Mashup.Engine.Interface.ReadOnlyAstVisitor.VisitExpression(IExpression expression) at Microsoft.Mashup.Engine.Interface.ReadOnlyAstVisitor.VisitModuleMember(ISectionMember moduleMember) at Microsoft.Mashup.Engine.Interface.ReadOnlyAstVisitor.VisitListElements(IList`1 list) at Microsoft.Data.Mashup.DataSourceDiscoveryVisitor.VisitDocuments(IEnumerable`1 documents) at Microsoft.Data.Mashup.DistinctDataSourceDiscoveryVisitor.FindDataSources(IEnumerable`1 documents, MashupDiscoveryOptions options) at Microsoft.Data.Mashup.MashupConnection.FindReferencedDataSources() at Microsoft.PowerBI.DataMovement.MashupContractConversion.MashupContractConversionUtils.TryExtractDatasourceReferencesFromMashup(String mashup, Boolean isMashupPlainText, IList`1& datasourceReferences, IList`1& errorDetails) 

Also, when I try a manual refresh, I get the following error:

There was an error when processing the data in the dataset.

Please try again later or contact support. If you contact support, please provide these details.

    Data source errorUnable to refresh the model (id=3546854) because it references an unsupported data source.
    Cluster URIWABI-EUROPE-NORTH-B-redirect.analysis.windows.net
    Activity IDcd00d1a2-107e-45fd-9ff2-3ab60ecae40c
    Request IDf52fd1ae-ea9d-7d9b-d311-e187e86814ad
    Time2020-07-06 07:13:10Z

I would greatly appreciate any assistance.

Thank you in advance.

[Anonymous]

Hi @daniBBB ,

Have you tried add a new data source in gateway for the new dataset? As far as i know, Once you delete the dataset the datasource in the gateway will become invalid even you publish the dataset again.

Best Regards,

Jay

[daniBBB]

I didn't try that. Although, as mentioned, without doing that it is now working, using the same data source as before. So I'm pretty confused.

[avinaash]

Hi @Anonymous ,

I have not deleted any dataset.

I tried adding any new data source to the existing gateway, but I am not able to so. After publishing the file, the Power BI is not able to discover my data source. And it is throwing weird errors.

Thanks in advance

[avinaash]

I am also facing exactly the same issue. Please someone help ASAP.

[daniBBB]

Hi avinaash

I had python script running in my report to transform my data. I managed to do the transformations natively in Power BI.

Once I removed the python script, I was able to refresh the report again in Power BI Service.

I know that this is not really a solution, but the workaround worked for me.

[avinaash]

Hi @daniBBB ,
But I already do the transformations natively in Power BI. I don't use any kind of script.