Forum Discussion
Refresh Schedule Help!
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
I would sit with a DBA and look at the queries hitting the database from Power BI and make sure there is not any database tuning that can be done to prevent time outs - indexes, remove cartesian joins, different table structures, etc.
If the part numbers are grouped in any way and the groups are fairly stagnant, and certain users only need to see certain groups, maybe you could have a table with the part numbers and a group id, then you might get some more speed with row level security based on the user - https://docs.microsoft.com/en-us/power-bi/service-admin-rls. You could set the row level security to the part number groups that apply to each user or user group.
Other than that, I don't know what you could do.