Create a Function to Direct Query SQL Server Table

[Marco_Iac]

HI,

i create this function to import table by insering the table name from a SQL server with mor then 10k tab (Get data show only the first 10k table).

Is it possible to create something similar that Direct query a table instead import?

This is the function code:

i found some workaround like direct query a table and then change the name in advenced editor but  i need do this with a function,

Thanks

[v-alq-msft]

Hi, @Marco_Iac 

It is unsupported to change connectivity mode in PowerQuery. The Storage mode property is a property that you can set on each table in your model and controls how Power BI caches the table data.

There are some limitations for DirectQuery. In DirectQuery, there are very limited Power Query functionality and DAX functions are limited. For further information, please refer to the following document.

Manage storage mode in Power BI Desktop 

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.