Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.