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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Reddy5833
Helper II
Helper II

DataMart refresh fails when try to add another (SharePoint) source to existing data mart.

I have created 2 DataMarts with ODBC(Redshift) data using a common gateway, I was able to refresh both successfully. But, when I attempt to add another data source (SharePoint) to one of the data marts, it started showing error and refresh fails. (Note: I have not fully connected to the SharePoint and imported any data, I have just clicked on 'Get Data' option, choose 'SharePoint folder' data source, entered the SharePoint URL. Click on next, it showed me the list of tables, I just stopped at this step and cancelled the process).

Reddy5833_1-1678700083007.png

Now my data mart has become useless since it is not getting refreshed and/or there is nor provision to delete the tagged data source.

The other DataMart connected with ODBC(Redshift) which is using the same gateway is refreshing successfully.

I have another data mart with only SharePoint data which is working fine too. This issue is occurring when I try to combine 2 different data sources in a single DataMart. 
Can somebody help me to fix this, Please let me know if you need any other details, Thanks in advance.

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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