Forum Discussion
Anonymous
6 years agoNot applicable
Adding days since from a SQLdb Report
Good Morning PowerBI! I have a report that queries a sql db directly and noticed if I added tables, it changes the type of report which will download all the tables which takes a while. I was...
v-lionel-msft
6 years agoCommunity Support
Hi Anonymous ,
If you don't want to load all the data every time you refresh, you can use incremental refresh.
Incremental refresh in Power BI
Or you can add sql statement.
We mainly use M language to deal with the problem of connecting data sources. DAX is generally used to model data.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.