cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jmiridium
Helper IV
Helper IV

Refresh Error: Unable to refresh the model (id=2682215) because it references an unsupported data so

How do I begin to troubleshoot this error:

 

Data source error:Unable to refresh the model (id=2682215) because it references an unsupported data source.
Cluster URI:WABI-WEST-US-redirect.analysis.windows.net
Activity ID:e5a948ff-2e26-45b5-a483-09d0c75f2ec2
Request ID:b9020074-8d04-1bbb-8175-8d1a89e316d8
Time:2017-06-20 22:46:10Z
11 REPLIES 11
Anonymous
Not applicable

Download the PBIX file to your desktop and open it in your PowerBI Desktop.  Go into the Edit Queries section and Refresh all.  This should tell you which table is erroring.  From there you can look at what data source its attempting to connect to.

Refresh works from desktop

refreshdesktop1.JPGrefreshdesktop2.JPGrefreshdesktop3.JPGrefreshdesktop4.JPG

If I refresh and publish the dashboard shows the data refreshed. However I can't refresh from the web interface

Anonymous
Not applicable

Looking at the error it seems like the error isn't that you have an unsupported data source, its that you have a data source that isn't compatable with Power BI Service handling the refersh.  In your Power BI desktop you will have an option 'Edit Queries' in there you can click 'Data Source Settings' which will list your data sources.  What data sources do you have?  I'm expecting one or more of these will be the issue.

https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-data/

The refresh works in PoweBI Desktop though

@jmiridium,

Some data sources are supported to refresh in Power BI Desktop, but not in Power BI Service.

To troubleshoot the error in your scenario, we need to know what data sources are contained in your dataset. In Power BI Desktop, please go to File -> Options and settings ->Data source settings to check data sources, and post a screenshot about the data sources.


Regards,

 

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi I have the same error, my data source is

amaquivar_0-1652975620207.png

is this supported to refresh in Power BI Service?

Hello,

I have the same error, I have 2 kind of data:

web api and excel sheet(sharepoint) in the same table

in the power bi desktop the refresh work, but when I publish it on power bi online it doesn't.

 

Have you any idea about, how i can make it run,

 

thanks in advance.

 

 

Capturex.PNG

Hi Did you get any solution for this ?

I have both personal and on site gateways. How come I can't pick a gateway at all considering I have an on site gateway?

 

onpremise1.JPGonpremise2.JPG

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors