I recency was asked to change all my databricks import tables to directquery. I did that using the TMDL option (which wasn't awesome). I want to keep the directquery connection, b...
...licers are being used. We have to use DirectQuery to fetch the data as we have the RLS enablement as well at databricks level depending on the user who uses the report. We see the query generation u...
Hello, i have large model that every fact table has more than 100m of rows is it better to be directquery or import ? i have prem workspace , and my question is for the s...
Hi Is it possible to directquery mySQL from Power BI in the same way as you can from MS SQL. Making it possible to have near live data in a report as opposed to only updating w...
Hi Everyone, I am working on Power BI Report which is having data from two sources oracle sql and dataflows. i developed this report in directquery . In the report, i want to c...
...assive size ~10GB and keeps growing. making it impossible to import and directquery blew through the free tier we had (still unsure about this error). How to efficeintly use massive data sets l...
Hello, I am using DirectQuery Snowflake table as data source. One of measures is working slow. I was thinking if DAX can be written in other way to speed up performance. D...
Hello Everybody, We have a PBIRS 2025-01 (Version1.22.9153.7886). I create a report with a DirectQuery connection to a SQL Server 2022. There is only 3 tables without relationship All w...
...want to add more. I need to use DirectQuery and a local model. When building everything is there but publised half of the report is missing. 1. Is there anything I can do on t...
...eports for each of our business areas, all coming from the same db. Would you: Use DirectQuery and do a single scheduled refresh overnight? Export to CSV for each of the business areas (a...