Forum Discussion
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) an...
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
But I cannot have database (refreshed via PBI Gateway) and excel tables (refreshed automatically from file stored on Onedrive), right?
