Forum Discussion

kconner's avatar
kconner
Microsoft Employee
10 years ago

data refresh issue - unsupported data source

I've read the existing posts on this but are of no help...

I have an excel file of 3..4MB as  my data source, loaded into powerbi.com

I created several reports and a dashboard off of it

upon trying to refresh the data source manually, i get the triangle error and this message which I'd love if someone  could offer some actually helpful solution...I've recreated the dashboard several times at this point and hugely irritated at this experience /inability to refresh.

 

Something went wrong.
 
An error occurred while processing the data in the dataset.
Data source errorUnable to refresh the model (id=xxxxxx) because it references an unsupported data source.
Cluster URIDF-MSIT-SCUS-redirect.analysis.windows.net
Activity ID3f50f6b5-01bd-ed21-9466-eba061497098
Request ID1bb077b0-5fac-fd12-58bf-c7180872c57e
Time2016-04-04 05:29:19Z
Need Help

11 Replies

  • Bogdan's avatar
    Bogdan
    Advocate I
    10 years ago

    Have exactly te same issue!
    Pro user, DataSet is stored in excel file OneDrive for Business.

     

    More over there also an issue with PowerPivot (Excel) it stucks and crashes for a secon day in a row...

    I've noticed, if I remove some measure or calculated column from my datamodel in excel and manage to save the file (without PowerPivot got crashed) then I able to update my dataset in Power BI, but just once. For a secon try I get the same error "unsupported data source".


    Maybe tha issue came with some recent automatic udpade for office 365 or something like that, because no such thing happened before. Working with this datamodel for a couple of weeks already.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    kconner Are you a free or Pro User? If Pro, do you have a personal gateway or enterprise gateway installed?

    • kconner's avatar
      kconner
      Microsoft Employee
      10 years ago

      The sad thing is (I'm new at this) and am unsure which user type I am. I do note that I don't have any gateways setup yet, and it is asking which one I want - personal or enterprise.  Is there a preference?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        kconner Well, first things first. You can quickly see if you are free or Pro. Click on the Gear icon (settings) and if under the "manage personal storage" you have something of 1GB - that's free, if you have 10GB, your Pro.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I know it is a little too late but has anyone discovered a solution for this problem? 

     

    I have the exact same issue. An excel file with a datamodel and a powerquery table. After importing de dataset to power BI, if i try to refresh it will display the error of Unsupported Data Source. 

     

    Greatly apreciate with anyone could help!