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

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.  

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors