SQL Server

[Naverie]

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?

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

[luisrh · Accepted solution]

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.