Forum Discussion

Naverie's avatar
Naverie
Icon for Helper I rankHelper I
5 years ago
Solved

SQL Server

Hi,   We have a report we have created using sql server connections and then tables created on the fly in Power BI.   The business is now wanting to publish this report but aren't able to as the ...
Direct Query
DirectQuery
On-premise data
On-Premise Report Server
Publish
Report Server
SQL
SQL Server Database
  • luisrh's avatar
    luisrh
    5 years ago

    I would suggest that you choose one way.  In PBI RS you cannot mix Import and direct query data sources.   When you say on the Fly,  are these being created thru M functions or are they dependent on joins to directquery data sources?   If you are going to stage data this way,  it's probably best you do that on the SQL end or just use import.    Again, all that depends on your use case,  but what you are wanting to do is not doable in PBI RS.  

luisrh's avatar
luisrh
Icon for Responsive Resident rankResponsive Resident
5 years ago

I would suggest that you choose one way.  In PBI RS you cannot mix Import and direct query data sources.   When you say on the Fly,  are these being created thru M functions or are they dependent on joins to directquery data sources?   If you are going to stage data this way,  it's probably best you do that on the SQL end or just use import.    Again, all that depends on your use case,  but what you are wanting to do is not doable in PBI RS.