Forum Discussion

rylach's avatar
rylach
Helper II
9 years ago

Using excel and database tables in one dataset

Hi,

 

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).

 

On the other hand, it should be possible to add the data from excel workbook with refresh, as  written in https://powerbi.microsoft.com/en-us/documentation/powerbi-service-excel-workbook-files/, but how to add it to existing (with SQL tables) data model?

 

Is it possible?

 

TIA

R.

2 Replies