Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
daniBBB
Frequent Visitor

Cannot Refresh SQL Database Data Source

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.

1 ACCEPTED SOLUTION
daniBBB
Frequent Visitor

I managed to figure out the problem.

It seems that Power BI started having a problem with my python data manipulation. I managed to do the required manipulation in Power BI natively and that fixed the issue.

View solution in original post

1 REPLY 1
daniBBB
Frequent Visitor

I managed to figure out the problem.

It seems that Power BI started having a problem with my python data manipulation. I managed to do the required manipulation in Power BI natively and that fixed the issue.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors