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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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

Top Solution Authors