cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nia9229
New Member

Report PowerBI Service SQL Server DirectQuery and Excel

I would like to know if it is possible to publish a report whose data sources are SQL Sever (DirectQuery) and an Excel spreadsheet(Import).

 

I created the gateway and the data source for SQL Sever on PowerBI Service. However, I can only see those visuals that works with Excel and I get an error message that there is no gateway available

1 ACCEPTED SOLUTION

It is still a composite model if you have independent tables with different modes in the same dataset.

If your excel file is on-premise ( in your computer, not in cloud), you should be able to add it to the gateway. All datasources that are not cloud-based, have to be added to the gateway.

View solution in original post

3 REPLIES 3
nia9229
New Member

Thank you for your answer.

 

I do not need to create a relationship between SQL Server and the excel spreadsheet. I guess this case is not a composite model because these objects are independent. They are used in different pages.

 

If I have understood correctly, I need to add all used datasources to the gateway even though they use the import mode. However, there is no Excel data source in the Power BI service. How can I fix this problem related to the spreadsheet?

It is still a composite model if you have independent tables with different modes in the same dataset.

If your excel file is on-premise ( in your computer, not in cloud), you should be able to add it to the gateway. All datasources that are not cloud-based, have to be added to the gateway.

Tutu_in_YYC
Memorable Member
Memorable Member

Yes you can, it is called composite model.
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models

Once you set up the gateway, you need to map them to the dataset under gateway connection.
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources#use-the-data-sou...

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors