Forum Discussion
data refresh issue - unsupported data source
yeah, the way that reads it "should" work = refresh powerbi as I update my excel file on onedrive. However, I still get the refresh error noted in original post re: unsupported data source.
kconner hmm. Is the Excel file a stand alone data source, or do you have it connected to a different source?
the excel file is sitting on my onedrive for business and the external data files I'm pulling into it are these three:
- a basic calendar from the azure marketplace (quite large , goes back to 1900's but I haven't figured out how to filter it down to only years I want when I import it from azure)
- a "standards" table I created in another excel file (7 rows)
- an "data sheet" containing all the records of interest (101 rows)
I did my dax coding and powerpivots in excel (using the "events in progress" modeling methods), then decided I wanted to try out the visuals in powerbi.
the interesting thing is that the last successfully completed refresh shows as a "scheduled" refresh on 4/1, which isn't supposed to be possible when source files sit on onedrive - where the refresh is supposed to happen automatically every hour.
kconner There are no hard and fast rules with files on OneDrive. It falls into the "depends on your scenerio"
Check out this site and determine what scenerio your Excel file falls under (which connections).
Is the "data sheet" a valid data source that Power BI can connect to?
Depending on the scenerio your Excel sheet falls into, you may need to install a personal gateway in order to refresh.