cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rylach Regular Visitor
Regular Visitor

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.

"First they ignore you. Then they laugh at you. Then they fight you. Then you win." - Mohandas Gandhi.
2 REPLIES 2
v-huizhn-msft Super Contributor
Super Contributor

Re: Using excel and database tables in one dataset

Hi @rylach

If you get data from excel stored in OneDrive or Sharepoint as the article said, you don't need to use gateway to refresh data. You can create the schedule refresh to refresh your data.


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

Best Regards,
Angelia

rylach Regular Visitor
Regular Visitor

Re: Using excel and database tables in one dataset

But I cannot have database (refreshed via PBI Gateway) and excel tables (refreshed automatically from file stored on Onedrive), right?

 

"First they ignore you. Then they laugh at you. Then they fight you. Then you win." - Mohandas Gandhi.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 33 members 754 guests
Please welcome our newest community members: