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).
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.
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
