cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Naverie
Helper I
Helper I

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 data needs to be converted to SQL.

 

However, from what I can gather (and I am certainly no expert) as long as the data is coming via a direct query to connect to the tables then this should be able to be published. There are some tables that need to be looked at as the below error message shows when trying to load the report, but once these are sorted you should still be able to transform the data within Power BI?

Naverie_0-1619182659419.png

 

If someone could help that would be greatly appreicated as I don't want to have to create all these new tables in SQL if not needed.

 

TIA

 

 

1 ACCEPTED SOLUTION
luisrh
Resolver III
Resolver III

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.  

View solution in original post

1 REPLY 1
luisrh
Resolver III
Resolver III

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.  

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