Forum Discussion
Refresh Schedule Help!
I believe Power BI Premium has unlimited refreshes - https://docs.microsoft.com/en-us/power-bi/service-premium, so that would be an option, but more cost than pro.
You could also look at your queries being sent to the database with a DBA and see if there are any long running queries, then work with a DBA to tune them to make your Direct Query queries run faster.
When you say you have trimmed the data as much as possible in SQL, are you trimming it based on time (last 30 days, last week, etc.) in the SQL model as well, or just adding new data to the existing data?
I looked at premium but the costs are way too high.
I only need data relating to a specifc part (which is linked to other tables and therefore need the data which is associated to the part). I looked at parameters, which i got working, however you needed to manually go into query to enter the part number. This is variable and could be any part number the user needs to select, I couldnt tie this to a slicer/filter so that it only queries associated to the parameter.
By trimming, I mean as many calculations done by SQL as possible, as well as removing any unneeded fields etc
What was the issue with tieing the part number to a slicer?
The part number needs to be the parameter, but theres no user friendly way of calling up the parameter (to enter the part number) as it has to be in the code for the query
