Is it possible to use in one data model / dataset tables from MS SQL and excel tables?
I have an MS SQL server connected to Power BI via Power BI Gateway, I can create (in PBI Desktop) and publish reports basing on the DB and then schedule refresh.
I'm trying to add to my datamodel some tables from excel file stored on Onedrive for business or Sharepoint site (in Power BI Desktop. file is connected directly, from local, synchronized with Onedrive / SP folder). Then, after publishing to cloud I cannot refresh the data - which seems reasonable (the datasource is local file).